Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Preventing and Fixing Corrupted Indexes
Message
De
12/10/2010 17:48:10
 
 
À
12/10/2010 17:20:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01485111
Message ID:
01485116
Vues:
74
There is no way to guarantee that corruption won't happen.

Application architecture has a big effect on corrupt index files. Don't every directly access fields in the DBF. Always use buffering. Add the FLUSH command after every save. Those things will help.

>It's an age old question, but how can we prevent indexes of native VFP DBF's from "corrupting"? we have already deployed daily "reindex" tools, but almost everyday corruption happens...
>
>Assuming we cannot resolve network (hardware) concerns, is there no other way to safeguard indexes from network interruption or other external factors that tend to cut connection to dbf server?
>
>Really need a solution for these, we have tried recoding our applications but to no avail.
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform