David Johnson wrote:

> 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.
>>

Inserting 1000 rows per seconds should be an easy target, provided your
network doesn't let you down.
Using a machine with a 800-900MHz (don't remember exactly) XEON processor
with fast disks (15000rpm) a program sustained 2000 records read from one
database and the same 2000 records inserted into another database (per
second). The program was run on the server.
Declared record length approx. 500B, probably expanded from and compressed
to about 50% of that. I believe this was Fb/0.9x.
The program was written as a general datapump utility, with Delphi and IBO.

--
Aage J.