Yes, I'm using views. This is an application that was not written by me, but was orignally a vfp5 app. The previous porgrammer likd views I guess.
Any fields used in the down the line final view, have indexes on all fields that are involved in that query. (I addded those a long time ago.) >From the coverage profiler, the other queries, run in <1 second. The one I want to speed up can take a long time on site, and is at least 10 times slower on my local machine than others. What I do in the load event of the form, is load all views, with NODATA of course, and then index the fields. I have separated out the code that creates the final view, wher prior to its execution, I requery all views. The one mentioned is the bottleneck. I also, have noticed that the sys(3054,11) sometimes reports a cartesian join, but it is not consistant. Also, on my local machine there is no speed difference if it does a cartesian join or not. Also, there has been discussion about a deleted index. How will that help? Doesn't that inde just slow things down on the network? Thanks again, 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.
