Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
REINDEX - Without EXCLUSIVE.
Message
De
24/10/2003 02:28:31
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00841224
Message ID:
00841954
Vues:
35
>Something we all should be doing on a regular basis is rebuilding Indexes. Simply relying on the REINDEX command is not necessarily the best route to go. Ideally the Tags should be dropped and recreated from scratch. This is a problem if the Tables are referenced by a DBC and have persistent relationships / Primary Keys / Candidate Keys or if you have systems that really do run 24 by 7.
>
>For a couple of months now some of the FoxPro community’s leading luminaries have had access to a utility I created that facilitates SHARED mode recreation of Indexes. I am now looking to find additional people to put this into their production systems and who are also willing to provide testimonials.
>
>Feel free to reply either to this post or using a private message.
>
>Regards to all,
>Houston.

Hi Houston.

I'll have a look at it for you too. I think the lack of huge response is probably because most developers have resolved themselves to developing systems to do this job in exclusive mode. But I'm not looking for an argument ;)
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform