On Thu, Jul 15, 2010 at 2:56 PM, Peter Hart <[email protected]> wrote: > Hi Tracy > > Yes The line before. > > The CDX is 123 megabyte. >
I'd suggest you drop all indexes before loading in the data, then SET TALK ON, and recreate all the indexes. You don't want Fox adding entries to indexes while it should be devoting time to adding DBF records. Serialize the two processes and see how that changes your performance. I suspect the command to close the table is finally forcing all of the cached data to be written to disk. Another alternative might be to reduce the memory allocated to VFP so it writes more during the process rather than at the end. Non-intuitive, but it might actually speed the process. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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.
