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.
Benchmark dbExpress & dbexpida.dll vs IB components & dbexpint.dll
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 ...".
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 ...".