Subject Re: [ib-support] insert optimization (long)
Author Tiberiu Atudorei
On Tuesday 27 May 2003 22: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).
>

Try to changeforced writes to 0. What was the value for your tests anyway?
Try also to change the cache parameters.