Devart Forums

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.

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.

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

Please specify what fields are in your test table.