Hi All.

I have a Db.
Must insert some data in a table.
First time of insertion take 15 - 20 seconds, that is fine.
After insert do some calculations.
Empty the table.
Reinserting data .... and take now 3 minutes.
every empty ... insert cycle take more time each, from 3 mins to 6 mins
and so on.

********************************************************************
Snippet of code I use:

delete from table1 where mycode > 0;
execute statement 'set generator gen_test_id to 0';

for select RDB$INDEX_NAME from RDB$INDICES into :index_name do
execute statement 'SET statistics INDEX ' || :index_name || ';';

*********************************************************************


There is something more to do?

Thanks
Arn