Of course it can....if you have 4 indeces, every time you insert a row on
the table the database has to reorganize 4 other "tables"(they aro not in
fact tables, are B-trees), one for each index....the best thing to do is
deactivate the index before insert and activate it after insert.

Diego
icq : 86406546
www.cartonline.com.br

----- Original Message -----
From: "fabiano_bonin" <fabiano@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, February 10, 2004 6:22 PM
Subject: [firebird-support] About large inserts speed in Fb 1.5


> 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?
>
> Thanks.
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>