I thought I read somewhere that REINDEX does not reduce bloat and that to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: [email protected] Subject: Re: Do you rebuild your indexes every night or do you leave them alone. I've seen CDX size divided by 10 after REINDEX Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 09/11/2016 à 16:25, Kevin J Cully a écrit : > Every night? I've gone years without reindexing DBF tables. Perhaps I'm > weird but if the network and server are in a good, healthy shape then I think > that the CDXs can be left alone under a moderate load. > > -Kevin > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Michael > Madigan > Sent: Wednesday, November 09, 2016 5:49 AM > To: ProFox Email List > Subject: Do you rebuild your indexes every night or do you leave them alone. > > I've been rebuilding indexes every night, does it really make a difference? > > How many people rebuild each night and how many leave it alone? > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[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.
