> From: "Fabrice Aeschbacher"
> > Do you have any DB connections (in actual fact transactions), that
> are open
> > for a long period of time.
>
> As long as the DB size is < 2Gb, I can use gstat, which tells me that
> all transaction are correctly committed, the gap between OIT and next
> transaction is constant. As soon as DB gets > 2Gb, gstat exit with an
> error (File too large). But I'm quite sure that every transaction is
> opened and immediately committed.

Even if all your transactions are short, you have to touch deleted records
in order to remove them from database completely, e.g.
- by sweep,
- by counting rows (SELECT COUNT(*) FROM TAB;) or other command
that do natural scan of table ...

You can find out how long are version chains by using "-r" switch of gstat.

(The limit of gstat to 2GB was discussed very long time ago,
so I was under impression it was already fixed ...)


Ivan
http://www.volny.cz/iprenosil/interbase