>> Anyway, have you ever been constrained by this issue?.<< Years ago conventional wisdom and real life experience showed adding a DELETED() index to a table improved Rushmore performance if you have SET DELETED ON. Then came an article in FoxPro Advisor that showed conclusive evidence that this was not always the case, and in some cases, was actually slowing queries down. Basically, if you have a table without any deleted records you have one tag that has all the same values, and thus does not provide any advantage to optimizing a query. It is easier to SET DELETED OFF before running the query. In addition the additional tag adds to index cache sizes, is a reason indexes to get out of date triggering more network traffic, and was one more additional tag to check when manipulating the data in the record.
The Binary tags were added to Visual FoxPro to address many of the problems cited in the article and help with performance. Obviously Microsoft has noted the threshold where the indexes become useful. In my personal experience I have not seen them hurt me so obviously our customer's data has deleted records. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ 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/002c01cbc99e$19934a10$4cb9de30$@com ** 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.
