Subject Re: [firebird-support] Re: Large database performance on Firebird 1.5.2 CS with 130+ clien
Author Thomas Steinmaurer
>> > No, the DB is used alway under ClassicServer
>> >
>> >
>> > Database header page information:
>> > Flags 0
>> > Checksum 12345
>> > Generation 11824495
>> > Page size 8192
>> > ODS version 10.1
>> > Oldest transaction 11820752
>> > Oldest active 11824393
>> > Oldest snapshot 11824393
>> > Next transaction 11824395
>> > Bumped transaction 1
>> > Sequence number 0
>> > Next attachment ID 0
>> > Implementation ID 19
>> > Shadow count 0
>> > Page buffers 0
>> > Next header page 0
>> > Database dialect 3
>> > Creation date Dec 24, 2004 13:04:10
>> > Attributes
>> >
>>
>>
>>I don't remember the default number of page buffers, but multiplying
>
> 130
>
>>users with 8KB page size and number of buffer pages -
>
> 130x8xBufferSize (in
>
>>KB) - may indicate if there is enough RAM (sorts may need additional
>
> RAM).
>
>>Otherwise, the statistics looks ok. (But I never used ClassicServer
>
> or Linux)
>
> I've created a script that do a monitoring of FireBird Number of
> Process and Firebird ram used.
> It don't use all RAM, it use very few RAM.
>
> If i remember Page Buffers 0 Mean that it don't do a Buffers of query
> (in other word it is disabled by default)

0 means, a default value of 75 pages per client connection per database
will be used with Classic. Of course, if you aren't using the parameter
DefaultDbCachePages in firebird.conf.

Memory shouldn't be the problem in your case.


Regards,
Thomas