Thanks Christoff .... and a good idea which I'll implement. We seem to have a particular table that suffers more than normal from Index bloat and I'm sure it is to do with the fact that the app is constantly modifying memo fields but also updating index records.
Dave -----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Christof Wollenhaupt Sent: 06 March 2014 11:05 To: profox@leafe.com Subject: Re: VFP Indexes... > > 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 --- [excessive quoting removed by server] _______________________________________________ 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/18725b8cd2d5d247873a2baf401d4ab22a4d8...@ex2010-a-fpl.fpl.LOCAL ** 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.
