> My Firebird database file size increases heavily although I just store
> records temporarily. Each 58 seconds two tables are filled and emtyed
> afterwards plurally. In my tests, amount and size of data is always exactly
> the same. The only way to squeeze it, is backup and restore using gbak. But
> gbak -r needs a closed database and my app. must run 24/7. Tables are
> accessed by IBO's Table component. Is there any workaround?

You have something staying open, and so the records can not
be reused. I run 24/7 without any problem now, just close
and reopen connections or at least do a commit on ALL
transactions at a regular interval.

I had a situation where a 5Mb database could grow to 200Mb
in minutes when BDE was involved, not seen that since
switching to IBO <g>

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