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 _______________________________________________ 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.
