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

how are you doing the insert?
INFB - Have you declared the text file as an external table? Do you then
issue
INSERT INTO INTERNALE TABLE SELECT FIELD1, FIELD2, ... FROM EXTERNALTABLE
?
Or are you using some other form of datapump?
Alan