Subject | AW: [ib-support] Re: Problems with gbak |
---|---|
Author | Henner Kollmann |
Post date | 2002-03-25T08:57:35Z |
> before finding the item. Deleting/changing the last record that wereTried your suggestions - delete first record, delete last record. Every
> 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.
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