Hi Lester,

Thank you for your help as well.

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

No, not exactly but when a "compressed" empty DB is 913 KB and each 58
seconds I add and delete always the same bunch of data then, as I understand
the IB docs, DB size should not keep on growing after a few adds/deletes
because empty space is being reused. After the first adds/deletes size grows
to 1019 KB and within 24 h up to ~10 MB so there must be something wrong.
Possibly the short interval or any special behavior of IBO in a TThread that
I'm missing?

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

One primary on each table, one secondary on the detail table.
Most data is VarChar (file pathes) in detail table, also one blob type text
in master table.
Actually master gets 2 records, detail 42 records (it's not a joke).

>
> 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.

Currently my changed app. is running for 2 hours, actual size is 1.3 MB. I
cannot say how size increases on each loop because the Windows Explorer
seems to refresh file size incorrectly but it still grows.

> 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.

There are no views, nothing is watched it's just a very simple db action, as
I wrote before.

Thanks again

Arno Garrels