Subject | Re: [firebird-support] Re: Large database performance on Firebird 1.5.2 CS with 130+ clien |
---|---|
Author | Aage Johansen |
Post date | 2005-03-24T17:47:24Z |
lins_kun wrote:
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)
--
Aage J.
> ...I don't remember the default number of page buffers, but multiplying 130
>
> 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
>
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)
--
Aage J.