Interestingly enough, changing over to Firebird1.5RC3 CS, without even
attempting to optimize the database, i get 657534 records inserted in
107 seconds (6145.17757009346 records / sec). Rock on Firebird.

Adding -housekeeping 0 and -buffers 8192, i get 657534 records inserted
in 126 seconds (5218.52380952381 records / sec), and a segmentation
fault. Not sure whats up with that.

I have posted a patch to the dbi-interbase sourceforge page that seems
to add firebird 1.5 support if anyone wants it.

--erik


Erik S. LaBianca wrote:

> Yes, I did try it. It knocked off about 10 seconds off the 5 minute run.
> See my earlier email for details.
>
> --erik
>
>
> Svein Erling wrote:
>
>>Did you try my suggestion to commit every 10000 records rather than
>>every 1000? As you say, 2000 rec/sec is pretty good, but if run on
>>decent hardware it should be possible to make it run faster than
>>that. After all, your table was pretty simple with only a few small
>>fields wasn't it?
>>
>>Set
>>
>>--- In ib-support@yahoogroups.com, "Erik S. LaBianca" <erik@t...>
>>wrote:
>>
>>
>>
>>>That being said, 2000 records/sec is still pretty good. :)
>>
>>
>>
>>
>>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