Some questions:

1) Does the indexes have low selectivity (i.e are there many duplicate
values)?

2) How do you insert records from a table to another?

3) If it is only one statement of the type INSERT INTO... SELECT...
then take the select part separately, prepare it and report to us the
plan and a bit about the tables and all the indexes in it.

Set

--- In firebird-support@yahoogroups.com, "fabiano_bonin" wrote:
> I remember some months ago, when i was testing early releases of FB
> 1.5, i was surprised with the speed of INSERT statements (INSERT
> INTO ... SELECT ...)
>
> Now i am trying to insert the records from a table to another (just
> about 60.000 records) and, after 30 minutes, the statement is still
> running.
>
> I tried the same statement in diferent boxes (windows/linux) and had
> the same results on both. The table where i am inserting the data
> has no triggers, calculated fields, etc... Just 4 indices, all on
> INTEGER fields. Both tables are in the same database, and i am using
> IBExpert to run the statement.
>
> My FB version is 1.5 RC8, on both Windows and Linux machines.
>
> While i was writing this post, i noticed that if i deactivate the
> indices os the destination table the insert is almost instantly. Can
> some indices affect the speed this much?