Subject AW: [ib-support] Re: Problems with gbak
Author Henner Kollmann
> before finding the item. Deleting/changing the last record that were
> inserted should be instantaneous.
> A remedy: Append the PK field to the indexed item (field +
> PK) which will
> make the index unique - delete/update will be real quick.

Tried your suggestions - delete first record, delete last record. Every
thing works quit well.
Only start of backup will not work.

Maybe you have an idea: I need something like the truncate command in
Oracle.
1. Have a table with 2.500.000 records.
2. Remove all records from this table.
3. Insert 4.500.000 records again.

After this procedure the database grows for 400 MB.

This will happen once a week. My first approach for this problem is to
make backup restore cycle to compress data and force a GC.

There the problem starts...

Henner