Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting indexes
Message
De
08/07/2000 23:13:49
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00389651
Message ID:
00389917
Vues:
17
Hi Vin,

Yes, but there can be multiuser considerations. Sometimes you have to bite it and go the slow route if other users could be on the system at the same time.

>Well, that could be the case, but there are many situations where deleting the indexes make sense. I've found that on slow networks in particular, the time required for importing 200,000 records (and updating say 4 or 5 index tags on each new row) is a lot more than the time required for importing without a reindex and then re-creating the tags. I first noticed this when I was involved in programming mass conversions of data into version 2.x tables, and with each subsequent upgrade, I have not found any difference in speed. The moral: definitely worth considering, and depending on hardware setup, may or may not make a difference.
>
>(A footnote: I did not always find this to be the case if the import was to a RAM drive, and then the files were copied en masse from the RAM drive to the physical drive.)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform