Subject Re: [ib-support] Re: Firebird slows after some Hours with 40+ Users
Author Zdeno Jasek
Hello, dimi1309,

set sweep interval to zero - your database is doing garbage
collecting every 20.000th transaction. And that takes a lot of time.
It is better to run garbage collector manually.

Zdeno


> 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."


> Yahoo! Groups SponsorADVERTISEMENT

> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com



> Your use of Yahoo! Groups is subject to theYahoo! Terms of Service.