> I changed the source to Explicit Transaction handling.
> Now Commit is called whenever it might be usefull, but the problem remains
> the same.

Have we established how much data SHOULD be in the database?

How many indexes are being filled, and what actual data is
being pumped in? (Can't see original post <g>)

I get 4-5Mb database with a couple of hundred train records
- it grows while I am building 'working' space and then
settles after 24 hours as old records get deleted every hour
and new ones added.

My equipment database never grows once in use as no new
records are added to that, just status entries changed.

One think to watch out for is not to use IB_SQL to watch
things, that holds a separate transaction and can cause
problems. The same sort of thing can happen if you hold
views open in the application.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services