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:profoxtech-bounces@leafe.com] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: profoxtech@leafe.com 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:profox-bounces@leafe.com] 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]