Following up on recent posts where I was trying to determine why a simple sql select was so darned slow .... I've spent a long time on various attempts to speed up the issue
I discovered it was really only an issue if the "select * from winhst where client=trcask into table tmp " was done where the data was on a network server. I also discovered that my client typically only wanted to "see" the data. My system assumed they now wanted to print copies of invoices, or follow it up with reports and the like. So......I now simply "set key to trcask" The result is instant Great outcome (in this instance) But, in the course of all of this, many other issues came up e.g. Mike suggested I take a look at sys(3054) I did and found that no matter what I do, I can only return a "partial" Rushmore level So I tried the following Use temp exclusive index on client tag temp1 **client is always upper, C(10) set order to 1lcSearch='ABCD' select * from temp where client=lcSearch into cursor tmp The sys(3054) returns a partial optimise only Now I've checked the helpfile and read the Rushmore sections 3 times, and then again by going backwards I'll be darned if I can find why I can "only" get partial optimising I need a sleep -- Regards Sytze de Boer Kiss Systems --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
