Subject Insertion speed
Author Todd Pinel
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.

[Non-text portions of this message have been removed]