On Wed, Apr 2, 2008 at 10:58 AM, Mike yearwood <[EMAIL PROTECTED]> wrote:
> Hi Gil > > > Message: 7 > > Date: Wed, 2 Apr 2008 10:13:07 -0400 > > From: "Gil Hale" <[EMAIL PROTECTED]> > > Subject: > To: [EMAIL PROTECTED] > > Message-ID: <[EMAIL PROTECTED]> > > Content-Type: text/plain; charset="us-ascii" > > > > SNIP!!! > > >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. > ----------------------------------------------- Indexes are real time. Either they are present in a cdx or not. The order of them will NOT change any issues of overhead in index adjustment(s) for your append or input statements. for you idx fans out there you know you need to open them as needed to be adjusted. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
