--- In firebird-support@yahoogroups.com, "Todd Pinel"
<todd_pinel@y...> wrote:

> Hi I was wondering what kind of performance is normal to expect when
> inserting multiple records into Firebird? The scenario I have right

now is

> I call a stored procedure that runs a For..Select to gather a list

of people

> that need to be inserted into another table. This query is simple

basically

> select all people with this attribute. I have in the past been able to
> optimize this For..Select query to improve speed but this time I'm

wondering

> if it's just the # of records I am trying to insert which is taking

so long.

> There are no other stored procedures or triggers involved in this

procedure

> andI insert roughly 15000 records and its taking about 1.5 minutes. Is
> there someway or technique I could use to improve this speed? Tia Todd.

Do you have indexes defined on the table? If yes you could try to drop
them first, then insert all rows, and then re-create the indexes. This
is usually faster.