> > Apart from the obvious decrease in performance, does anyone know how to > find out how fragmented/overflowed VFP indexes are in a similar way to how > you can find out the fragmentation of SQL indexes? >
We keep track of the file sizes after the last reindex. Then you can estimate fragmentation with: ( ((newCdxSize/newDbfSize) / (oldCdxSize/oldDbfSize)) -1 ) * 100 If this is 50, then index grew 50% more than the DBF file. It's only an estimate, since indexes a compressed, so the actual space needed depends on the data in the table. But it's good enough to trigger a reindex, when combined with the growth in file size for either CDX or DBF file. To calculate the precise amount of empty space vs. used space in the index, you need to scan the CDX file which is a low level operation. -- Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAL4QJhjTtYtkrkn1+k5uBuVg=fcug60qifuppxoa0mugrs1...@mail.gmail.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.