For "whatever reason" I never used INSERT INTO. Just a TWWADIism I guess (The Way We Always Did It). Another approach to test. Very cool. Thanks!
Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Bill Arnold > Sent: Saturday, April 07, 2007 7:55 PM > To: [EMAIL PROTECTED] > Subject: RE: PostgreSQL text file import performance > > > > Gil, just a comment or two on loading large files: > > > - INSERT INTO is much faster then append. Here's some stats I collected > when optimizing the loading of large tables (IIRC these particular stats > came from Paul McNett). > > > *Append/Recall method (original code): > *Pass 1 9.914 > *Pass 2 11.525 > *Pass 3 8.848 > * > *FPUTS() method: > *Pass 1 1.322 > *Pass 2 1.280 > *Pass 3 1.303 > * > *INSERT INTO method: > *Pass 1 1.269 > *Pass 2 1.385 > *Pass 3 1.483 > > > - Also consider using pre-loaded tables as targets, replacing 'empty' > records instead of using APPEND/Insert into. > > - I probably read this too fast, but why buffer the target table? > > > > Bill > > > > > > This is a long one, more about some behavior I have found > > using PostgreSQL with VFP, and a bit hoping someone has come > > up with a solution better than the one I came up with off-the-cuff... > > > > Over the past many years I have been pulling raw data off > > various Unix and Linux minicomputers, and converting the > > contents of the text files into data used to populate/update > > various VFP tables. And I have several commercial accounts > > that need me to update certain data daily, which I peel out > > of the some of my VFP tables, place into a .csv file, and > > upload to their various ftp Servers (all AutoMagically, of course). > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
