Won't you need the indexes? You drop them before the import for speed. Otherwise, each index has to be updated.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Sent: Thursday, July 15, 2010 2:44 PM To: ProFox Email List Subject: RE: Visual Foxpro freezes after processing a large table. Thanks to you and Stephen for those comments. Tomorrow I am going to move the data to the desktop machine and try it. It won't be running on a server at the clients anyway. Once I have times for that, I will do as you suggest about dropping the indexes then recreate them after the import. But that part of the process is not much of a problem. Do you think I ought to Drop them again before I close the table. I wouldn't have to drop them at the start then. Cheers Peter Peter Hart Computers. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ted Roche Sent: 15 July 2010 20:16 To: [email protected] Subject: Re: Visual Foxpro freezes after processing a large table. 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 [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/055301cb2456$613baf80$23b30e...@[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.
