Subject | Re: [ib-support] Firebird slows after some Hours with 40+ Users |
---|---|
Author | Martijn Tonies |
Post date | 2002-12-10T08:25:19Z |
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.
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."
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 isrunnin=
> g 24/7, peak we have 50+ Users. CPU-Usage grows ap. 100 times and requestgo=
> from 2 sec to 40-60 sec. We replaced all "edit" Transactions withMemorytab=
> les, but there are still some "readonly"-Transactions. Replacing themwould =
> blowup the Client. We are using Delphi6 with IBX. Between OIT and OAT areap=
> 15000 till 20000. The Server is a Dual-P3 600 MHz with 1 GB Ram withWin200=
> 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."