Ah! A good question. In reality I don't. I'm inserting a lot of records,
and it takes an appreciable amount of time, so I'd like to make sure i'm
doing it as fast as possible.

I'm working on another app in delphi that also needs an import routine,
and likewise I need it to run as fast as possible, since some of the
datasets are quite large and the customer has to sit there watching
while it runs.

That being said, 2000 records/sec is still pretty good. :)

--erik


Martijn Tonies wrote:

> Hi,
>
>
>>Thanks for the suggestion. I installed MySQL 4.0.13, and changed my
>>script to create an InnoDB table. I was able to achieve 657534 records
>>inserted in 164 seconds (4009 records / sec).
>>
>>Any other ideas?
>
>
> Why do you need to insert 4000 rows/sec?
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
>
>>Thanks
>>
>>--erik
>>
>>
>>Edwin Pratomo wrote:
>>
>>>On Wednesday 28 May 2003 02:11, Erik S. LaBianca wrote:
>>>
>>>
>>>>Daniel, Svein
>>>>
>>>>Thanks for the replies. I'll try to be more clear.
>>>>
>>>>Since the delphi+ibx situation has a bunch of other contributing
>>>>factors, i'll stick to the perl script i'm using for now. It DOES use
>>>>prepared inserts. I'll include the bulk of it below.
>>>>
>>>>The reason i feel it is slow, is that I converted it directly from using
>>>>MySQL. I ran the exact code below today, on the same machine, with both
>>>>MySQL 3.23.56 and FireBird 1.5RC2 using local connections to files on
>>>>the local filesystem. MySQL inserted 657534 records in 161 seconds (4084
>>>>records / sec). InterBase inserted 657534 records in 294 seconds (2236
>>>>records / sec).
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--
Erik S. LaBianca <erik@...>
Developer / System Administrator, Interlink, Inc.
Voice: (269) 473-3103 Fax: (269) 473-1190
http://www.totalcirculation.com