Subject Re: Large database performance on Firebird 1.5.2 CS with 130+ clien
Author lins_kun
--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
> lins_kun wrote:
> > ...
> >
> > 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)