From past experience, you should be able to exceed 1,000 rows inserted
per second for straight insertion on a table with a primary key only,
provided that is the only work occurring. You can expect half that or
less on a select + insert operation, depending on the exact operations
you are executing in the select and the other indexes on the insert.

On Mon, 2005-02-07 at 16:09, Todd Pinel 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.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>