REINDEX is OK when index definitions are still here
DELETE TAG ALL and INDEX merely rewrites index definitions in DBF header and DBC
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 18:51, mbsoftwaresolutions@mbsoftwaresolutions.com a écrit :
Thierry -- are you using REINDEX or DELETE TAG ALL and rebuilding each manually?
On 2016-11-09 11:31, Paul Newton wrote:
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/
[excessive quoting removed by server]