WOW!!!! THAT'S INCREDIBLE!!!!!!!
Importing row by row 3.600.000 records takes about 14 hours. Importing 1.160.000 records using an external table takes seconds, less than a minute. Thanks very much to all for the advice. Greetings. Walter. On Wed, Feb 6, 2013 at 2:49 PM, W O <[email protected]>wrote: > Thank you for the info Sean. > > Greetings. > > Walter. > > > > On Wed, Feb 6, 2013 at 1:25 PM, Leyne, Sean <[email protected]>wrote: > >> ** >> >> >> Walter, >> >> >> > Karol, currently now I am importing a .DBF table which has more or less >> > 3.600.000 records and it is taking hours. >> >> Back in 1994 I was able to insert 1000 rows/secs into a IB database from >> an DBF file. >> >> So, you need to review your import routine approach/coding. >> >> >> > Exporting the .DBF to a delimited text file and then importing using an >> > external table would be faster? >> >> Orders of magnitude. >> >> Sean >> >> >> > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
