Subject Re: [ib-support] Firebird slows after some Hours with 40+ Users
Author Martijn Tonies
Hi,

Can you list the database statistics? Especially transaction counter
information -
check the docs on how to do this or use your favourite GUI tool.

> we┬┤ve got an app that slows extremly down with 20+ Users, the app is
runnin=
> g 24/7, peak we have 50+ Users. CPU-Usage grows ap. 100 times and request
go=
> from 2 sec to 40-60 sec. We replaced all "edit" Transactions with
Memorytab=
> les, but there are still some "readonly"-Transactions. Replacing them
would =
> blowup the Client. We are using Delphi6 with IBX. Between OIT and OAT are
ap=
> 15000 till 20000. The Server is a Dual-P3 600 MHz with 1 GB Ram with
Win200=
> 0 Server, CPU-Affinity is set to 1.



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."