As with any import on any database, it is faster to load raw data vs. loading data from another database or program because of the overhead involved.
Dan From: Dennis McGrath Sent: Tuesday, August 21, 2012 6:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Slow Import by Gateway If you create a database with just the target tables and try to load the data what happens? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Richard Sent: Monday, August 20, 2012 10:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Slow Import by Gateway Recent efforts to load some large tables from MS Access via File Gateway have required extremely long times. One table of about 1,300,000 records with 60+ fields took 30 hours to complete. Is this just to be expected or might there be underlying inefficiency or setting that can be overcome the long load time? I also tried loading the table from a text file with about the same (lack of) speed. Loading the same text file into Access takes minutes. Whazzup with File Gateway?
