Subject Inserting records into database
Author Geoff Skerrett
Hope someone can provide some guidance/advise.

I have a .txt file containing approx 47,000 records and have devised a test
to insert these records into a RDMS.
The two I am using for comparison are MsSQL and Firebird.

It seems that firebird takes atleast 2x longer to run the insert than MSSSQL
(Firebird = 24 min, MsSql - 11.4 min).

Is there anything I can due to improve the results on the Firebird side ?
I created identical tables in both DBMS with all columns set to CHAR type so
I was trying to keep it similiar.
I don't have indexes on any of the columns.


[Non-text portions of this message have been removed]