Benchmark dbExpress & dbexpida.dll vs IB components & dbexpint.dll

webpac · Post by **webpac** » Thu 11 Oct 2007 13:49

Hello,

I benchmarked the time to insert 100 000 rows for a Firebird Database to another Firebird Database with IB Components & dbexpint dll and dbExpress & dxexpida dll.

The results are :
The components of the source request don't change the time.
The time is very dependant of the components of the destination request.

I commit the transaction every 1000 rows.

With IB composants, the insertion dures 30 seconds.
With dbExpress and dbexpida, the isertion dures 2 minuts and 30 seconds.

Do you think the difference is a limitation of dbExpress or a limitation of dbexpida.dll or a problem of configuration of objects in the code of my application ?

Thanks for your help.

Ps : I'm sorry for the enlgish faults, I do my best.

Plash · Post by **Plash** » Fri 12 Oct 2007 10:15

The performance problem is caused by dbExpress. I think it is not related to the driver and its settings.

I advise using Core Lab IBDAC instead of dbExpress.

webpac · Post by **webpac** » Fri 12 Oct 2007 12:32

Hello,

I tried with dbExpress and dbExpInt.dll, the time is 57 seconds.
I can't change all of my code now to use Core Lab IBDAC components witout validate dbexpida.dll is better than others.

Actually, the advatange of dbexpida is when a request doesn't work, the error is explicit and dbexpint displays a generic message "dbx error : no code ...".

Plash · Post by **Plash** » Wed 17 Oct 2007 10:51

Please specify what fields are in your test table.