I don't get corruption, I just do it anyway.
----- Original Message ----- From: Ed Leafe ed@leafe.com To: ProFox Mailing List profox@leafe.com Sent: Wednesday, November 9, 2016 6:26 PM Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
On Nov 9, 2016, at 5:05 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
The ProFox archives are stored in MariaDB, and I’ve never even considered reindexing. IMO, that sounds like something is wrong with your t t hardware if you find it necessary to reindex constantly.
-- Ed Leafe
[excessive quoting removed by server]