Mike, Have you got the "set tablevalidate 0" setting as this can slow down the opening of tables. An old chestnut I know but often forgotten.
Also someone else had a similar problem recently and it was down to inefficient non Rushmore optimized indexes so that is worth a look as you can be shipping literally megs of data in the form of index data otherwise. Also take a look at the "no data on load" settings when opening individual tables, but I don't really think that will be the reason. VFP 9 (SP1 of course) should be at least as quick as VFP5 and in all bar none of the cases I have come across when converting, considerably faster. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 October 2007 13:28 To: ProFox Email List Subject: Is there a difference on how data is handled in VFP9 vs VFP5? I have a VFP5 application that I am converting to VFP9... Everything is just fine except for one of the screens, in VFP5 it takes about 2-3 seconds to open, in VFP9 it can take up to 45secs! (Usually 20-25secs!) Of course in the development environment, it works great! I have recreated all queries, views, etc to use inner join syntax instead of where clauses, and this did speed it up, however... not enough. In the load event, there are some relations set, and a few views requeried. But as stated, they open quite fast, in the development environment if VFP9, and in the old VFP5 application. The question I have, is as stated in the subject line, what differences are there in the way VFP9 handles data from VFP5? Can these be the cause of the speed slowdown? Any ideas on how to speed this up? TIA, Mike -------------------------------------------------------------------- This mail sent through WebMail | Courtesy of Execulink [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.
