--- In firebird-support@yahoogroups.com, "Paul Beach" <pbeach@i...> wrote:

> > The application listens to an automatic switchboard and controls the
> > calls for the workstation. When it recieves a call it inserts several
> > records to different tables for statistics purposes. It also inserts
> > records for every event during and when it ends the call.
> > Every client recieves multiple calls over a short time.
> > Could this be a problem?
>
> Next time the database starts running slowly, post a gstat -h of the

database

> to this list....
>
> Paul

Hi Paul,

Today the database started to work very slowly.
When I performed a full validation I recieved that it found no errors.
After that I did what you asked me, and here is the result:
Database header page information:
Flags 0
Checksum 12345
Generation 178574
Page size 16384
ODS version 10.1
Oldest transaction 885
Oldest active 178534
Oldest snapshot 178534
Next transaction 178564
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jan 17, 2005 15:59:22
Attributes database shutdown

Variable header data:
Sweep interval: 20000
*END*

Any ideas?

BR
SvenJ