Life in a file server world compared to your data in a rdbms where you only get data through the api.
I haven't reindexed a table in my SQL servers in probably 10 years outside of freeing up wasted pages after a purge of a company's transaction data we sold off.
On Wed, Nov 9, 2016 at 5:18 AM, Ted Roche tedroche@gmail.com wrote:
Your last question was about FoxPro 2.6. Is this, because the version makes a difference?
In the more recent VFPs, CDXes are much more stable and don't need rebuilds as often.
And there is no "CORRUPT CDX" command in VFP; this is often indicative of an unstable network, or an app where the clients turn off their machines.
On Wed, Nov 9, 2016 at 5:48 AM, Michael Madigan mmadi10699@yahoo.com wrote:
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]