Subject Re: Firebird slows after some Hours with 40+ Users
Author dimi1309 <ich@dimi.mdis.de>
Database "d:/database/siemens.gdb"

Database header page information:
Flags 0
Checksum 12345
Generation 34340
Page size 16384
ODS version 10.0
Oldest transaction 16209
Oldest active 16210
Oldest snapshot 16210
Next transaction 34332
Bumped transaction 1
Sequence number 0
Next attachment ID 2
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 6, 2002 13:03:16
Attributes force write, no reserve

Variable header data:
Sweep interval: 20000
*END*


Database file sequence:
File d:/database/siemens.gdb is the only file

Database log page information:
Creation date
Log flags: 2
No write ahead log

Next log page: 0

Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
unavailable database

> 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 reque=
st
> 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 a=
re
> 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."