Subject | RE: [ib-support] low perfomance with intensive stored procedures |
---|---|
Author | Nigel Weeks |
Post date | 2003-06-19T22:43:42Z |
Super-server v Classic Architectures...?
To make use of Multiple CPU's, you need to use Classic.
As far as I know, some core routines inside firebird are still one-at-a-time
areas of operation.
(I am very willing to be wrong, however)
-----Original Message-----
From: Soporte [mailto:soporte@...]
Sent: Thursday, 5 June 2003 21:03
To: ib-support@yahoogroups.com
Subject: [ib-support] low perfomance with intensive stored procedures
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
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
To make use of Multiple CPU's, you need to use Classic.
As far as I know, some core routines inside firebird are still one-at-a-time
areas of operation.
(I am very willing to be wrong, however)
-----Original Message-----
From: Soporte [mailto:soporte@...]
Sent: Thursday, 5 June 2003 21:03
To: ib-support@yahoogroups.com
Subject: [ib-support] low perfomance with intensive stored procedures
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
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/