REINDEX is fine for working with the data in the IDE. It is true that a corrupted tag header will propagate with REINDEX, completely defeating the purpose of the reindex.
The bloat you are referring to is a huge deal, but it depends on the version of VFP. I think this changed in VFP 7. What happens when you REINDEXed is the original tag was marked deleted and a new tag is created. Effectively this doubled the index size (not exactly as deleted nodes are not created). This leads to bigger CDX files. Bigger CDX files are typically cached locally when working in a server environment. This means more network traffic and slower overall query and update performance. DELETE TAG ALL and INDEX ON will solve the problems discussed, and has been a best practice for years. It also will cause problems for you because it will drop persistent relations and referential integrity. This is why Stonefield Database Toolkit is a must have. It does everything for you and is easy to use. More details on index bloat here: http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP 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/[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.
