Arn wrote:

> 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
>

I think you are experiencing the garbage collection process time.

Try a select count(*) from each table you use prior to starting measure
the insert time.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br