Subject | low perfomance with intensive stored procedures |
---|---|
Author | Soporte |
Post date | 2003-06-05T11:02:55Z |
Hello from Spain,
we are running FB 1.0.2 in a new Dual Pentium III Xeon 2.4Ghz, over Windows
2000 Server SP3.
When we execute a intensive stored procedure, others transactions looks like
starved (80 connections), and the CPU load reaches to top (25% load, because
it has hyper-threading).
If the server has subprocesses, why does it run in a single cpu (rather, in
"half" cpu).
The process is faster than previous processes in a Dual Pentium III 800Mhz,
but looks like that it not balances load between all transactions.
thanks
we are running FB 1.0.2 in a new Dual Pentium III Xeon 2.4Ghz, over Windows
2000 Server SP3.
When we execute a intensive stored procedure, others transactions looks like
starved (80 connections), and the CPU load reaches to top (25% load, because
it has hyper-threading).
If the server has subprocesses, why does it run in a single cpu (rather, in
"half" cpu).
The process is faster than previous processes in a Dual Pentium III 800Mhz,
but looks like that it not balances load between all transactions.
thanks