> Do you remember my case? slow database. Then, through gstat we found bad
> transaction handle from application's side.
>
> I fixed up and now there is no gap between the OIT and the Oldest

Snapshot.

> Oldest transaction equals with Oldest snapshot (extreme equal), as you can
> see in the bellow gstat.
>
>
>
> After 2 weeks of usage, after backup restore, the database has begun to be
> slow again. Of course is not so bad case as previously but still something
> else is going wrong.
>
>
>
> Just to remind you:
>
> - The same application is running on different customer's branch
> with more daily movements and they have no problem at all.
>
> - The only difference between two branches is that the terminals
> (and server) of this slow database are never close (they never rest ;) ).
>
>
>
> Database "C:\Progra~1\Praxis~1\Trade\Database\ble_eg_pos.fdb"
>
>
> Database header page information:
>
> Flags
>
> Checksum 12345
>
> Generation 26825033
>
> Page size 16384
>
> ODS version 11.0
>
> Oldest transaction 4253402
>
> Oldest active 4253403
>
> Oldest snapshot 4253403
>
> Next transaction 26825027
>
> 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 3
>
> Creation date May 23, 2008

0:54:59

>
> Attributes force write
>
>
>
> Variable header data:
>
> Sweep interval: 20000
>
> *END*
>
>
>
> Do you see something wrong here?

Yes, a huuuuuge gap.

> What is the meaning of the "Next transaction" indication?

That you still have a transaction problem in your application.

You're saying that these "terminals" never close, does that include
your application? If so, does your application start a transaction
as soon as it opens? Or keeps 1 transaction for, for example, reading
all data? Does it ever COMMIT?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com