Subject RE: [ib-support] low perfomance with intensive stored procedures
Author Nigel Weeks
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/