|Subject||RE: [firebird-support] Inserting records into database|
> Hope someone can provide some guidance/advise.how are you doing the insert?
> 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.
INFB - Have you declared the text file as an external table? Do you then
INSERT INTO INTERNALE TABLE SELECT FIELD1, FIELD2, ... FROM EXTERNALTABLE
Or are you using some other form of datapump?