Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking index
Message
De
02/07/2003 15:05:05
Todd Zmetana
Night Owl Projects
Alberta, Canada
 
 
À
02/07/2003 13:26:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00778188
Message ID:
00806257
Vues:
30
>>I had a little program that would check the number of keys (records) in each tag and compare it against the number of records in the database file. If it didn't match, rebuild the index.
>
>Thanks for the reply, Vernon. Would you mind sharing that program here, or if not, maybe, explain how it worked? I'm starting to dig into the specifics of index files, and any jumpstarts would be appreciated.

Mike,

If you are interested (which I am sure you are) I have written a complete index tester program that I use on all our systems.

I was at the conference when Doug made the statement that it is easier to rebuild the indexes than to test them but with multiuser 24/7 systems I found it necessary to first confirm if there is an index problem before shutting the system down to rebuild the necessary indexes.

Todd
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform