Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to speed up
Message
De
17/11/2003 18:09:31
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
How to speed up
Divers
Thread ID:
00850812
Message ID:
00850812
Vues:
78
I had a large table (over 3 million records) with multiple indices which accidentily wound up with some duplicate entries. I tried to rectify this by creating a new unique index, copying to a temp file, zapping, appending from the temp file, and eliminating the new index. This worked fine, but now all sql commands I run on the table are taking much much longer than they had! Any thoughts? Thanks!!!!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform