Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking index
Message
From
02/07/2003 15:05:05
Todd Zmetana
Night Owl Projects
Alberta, Canada
 
 
To
02/07/2003 13:26:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00778188
Message ID:
00806257
Views:
31
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform