Subject Re: [ib-support] Re: insert optimization (long)
Author Edwin Pratomo
On Thursday 29 May 2003 06:46, Erik S. LaBianca wrote:
> 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.

unbelievable! with all that support of constraints (MySQL is very loose on
this) and it is still far faster!

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

Thanks, I'll look into it. actually I've been working on firebird 1.5 support
on my own cvs tree, and able to get it compiles with g++ (I'm using gcc-3.3).
But still can't get it to work, it fails somewhere in isc_attach_database().
No error message, no SIGSEGV (apparent from strace output). Just exits
silently.

rgds,
Edwin.