<snip>
Martijn, Thanks.

You've hit the problem.
All that slowiness was due to the indexes.
</snip>

I am glad you found the performance problem. In FB 1.5, a poorly
selective index can really penalise garbage collection. FB 2 is much
improved i this particular aspect. One of the problems you may
encounter is that a foreign key index may be by nature poorly selective.

As far as the database growing goes, does it increase from 7MB to 77MB
for one day, or does it jump from 7 to 9 to 11 to 13 etc as you do
each day? If the second is true, then I would guess that you have an
old transaction still running. Tihs transaction keeps the old inserted
and deleted records "interesting". Because of this, the space they
occupy can not be reused and the database file must therefore grow to
store all the information. One culprit is commit retaining (soft
commit). Although it commits the transaction, it retains the original
context so from a garbage collection perspective it is pointless.

Adam