Rick Tx for your very informative reply - I will need to look into the issue of RI and persistent relations
Paul Rick Schummer wrote: > 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 > > > > > > [excessive quoting removed by server] _______________________________________________ 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.
