Subject | Re: [firebird-support] Recommended firebird.conf settings for a classic server on 2003 |
---|---|
Author | Helen Borrie |
Post date | 2008-01-04T00:34:20Z |
At 10:21 AM 4/01/2008, you wrote:
Helen
>Here is the gstat info...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).
>
>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.
Helen