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