--- In firebird-support@yahoogroups.com, "Stefan G. Weichinger" wrote:

> Am 27.08.2010 21:27, schrieb Mercea Paul:
>
> > Can you give us a gstat -h for your database?
>
> sure, sorry. 2 days ago it showed the following for the big db:
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 4945
> Page size 16384
> ODS version 11.1
> Oldest transaction 4904
> Oldest active 4905
> Oldest snapshot 4905
> Next transaction 4907
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 32
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Aug 25, 2010 20:17:46
> Attributes
>
> Variable header data:
> Sweep interval: 20000
> *END*

Were these statistics taken from the database at a time when it was slow? I'm asking because it seems it might be the statistics from a freshly restored database, and statistics taken at a time when the database is responsive isn't anywhere near as useful as statistics taken when the database is slow. These statistics indicate that your transactions are well handled, but as I said - if it is taken at a time when the database behaves well, this might not be the entire truth.

Set