Subject Re: [firebird-support] Recommended firebird.conf settings for a classic server on 2003
Author Helen Borrie
At 10:21 AM 4/01/2008, you wrote:
>Here is the gstat info...
>
>Database header page information:
> Flags 0
> Checksum 12345
> Generation 911108
> Page size 8192
> ODS version 10.1
> Oldest transaction 894209
> Oldest active 894210
> Oldest snapshot 892992
> Next transaction 911085
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 3000
> Next header page 0
> Database dialect 1
> Creation date Nov 25, 2006 0:25:30
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
>So using your formula that works out to 24000 for the page cache size,
>significantly lower than the maximum you mentioned.

Er...no...it's 24576000 bytes, or 23 MB per process!! I wrote "Something around 300K would be the maximum". Chop the cache size back to 75 pages and see how you go on that (600K per process).

Helen