I did some work on a data conversion job where timing was critical so we investigated various ways to save time by running the same task written in different ways on identical machines. It involved importing anything from 1 million to 22 million records at a time into an empty table from a CSV. We found it significantly quicker to delete the indexes and import the data then add the indexes again. I can't remember the actual differences as it was some time ago.
John Weller 01380 723235 07976 393631 > > >I have no recorded time comparisons, just my gut feel based on years > of watching VFP import records from large csv files (millions of > records at a crack). And, for the record, when I do my imports into a > VFP table I leave any index/order set off, as having a table with an > active index/order will slow down an import process horribly with > large tables as VFP tries to rearrange imported records into the > active sort order... > > > > I don't think that's 100% accurate. If you have SET ORDER TO 0, but > still have a CDX, the cdx tags must be updated. If you have SET ORDER > TO something, I don't believe that slows down the APPEND FROM. - Can't > test it right now though. _______________________________________________ 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.
