From a performance point of view which would be the most efficient to use, USE_COROUTINES or LOAD_BALANCING_CHK on MaxDB 7.6 ?
I understand how LOAD_BALANCING_CHK(task switching) works but haven't been able to find much info on USE_COROUTINES, perhaps someone can clear that up for me ?
For info, I am running MaxDB 64bit on Quad dual core AMD HP Blade system with 18 GB ram. Currently MAXCPU is set to only 4 but I intend on increasing it to at least 6 as this is a dual core system, leaving 1 CPU for Operating System use. We are using SLES9 64bit currently but will be upgrading to SLES10sp1 in near future.
Any advice/comments ?