Subject | Re: [firebird-support] Inserting 100's of thousands from a SP |
---|---|
Author | Nick Upson |
Post date | 2005-07-08T14:42:50Z |
Suggestion:
insert all records into a table with duplicate structure to the final one
commit
then do "insert into real_table as select from dup_table"
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
insert all records into a table with duplicate structure to the final one
commit
then do "insert into real_table as select from dup_table"
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly