Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie Textbox question
Message
 
To
10/03/2014 13:30:21
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01595968
Message ID:
01596035
Views:
63
>The number of times I've had issues with CDX files going bad can be counted on one hand. In fact, my experience is that almost all corruption of tables or indexes boils down to failure to have a UPS or network trouble.

There is an issue with CDX files bloat when you have "circular" tables (tables where you keep the same number of records and you start overwriting when you get past this number, for example you want to have 500,000 records, so when you've got to write 500,001 you overwrite record 1) after a while you need to reindex for the CDX file size keeps growing and it either starts failing or you get to the 2 Gb limit.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Reply
Map
View

Click here to load this message in the networking platform