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

Indexes on CHAR fields can be quite large, but that should
not be a problem.

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

At that size there should not be a problem. Out of interest,
what happens if you DONT delete. Is the growth the same? In
which case something is wanting to see the 'missing' records.

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

This may be suggesting something. Windows will only see the
size change when the file is closed. If it is not seeing a
change, then the database is not getting closed, and perhaps
it should be.

I think that I would make the same suggestion I made to
another problem - IBLogManager.

http://www.iblogmanager.com

It has shown me a few niggles caused by automatic bits
happening in the background, resulting in extra activity
which in my case gave updates that should not have happened.
Not saying it will help, but it is an eye opener <g>

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