Hi Rajesh,

> Thanks for your prompt reply. Heres the GSTAT output. I am not sure what
> you mean by transaction counters. Like I said in my posting, I do not
> know how to interpret Gstat. If you or some one else could point me to
> the information I will read up on it.
>
> I forgot to mention that we are using SuperSever FB.
>
> Thanks again.
> Rajesh
>
>
> Database "d:\Firebird\TG.FDB"
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 14501
> Page size 8192
> ODS version 10.1

> Oldest transaction 14490
> Oldest active 14491
> Oldest snapshot 14491
> Next transaction 14492

These are the transaction counters.

Is this while the database is slow?

Many times when someone complains his app is slow, it's
because there are long running transactions, causing
lots of garbage/transaction information to be kept...

If these counters are from a time while your db app is
slowish, then this isn't the case...


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com