Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seconds to append 91K records: 60? 135? 1900?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00276272
Message ID:
00277183
Vues:
27
>>>Have you applied Visual Studio 97, SP 3 to VFP 5.0?
>>
>>
>>Ah, that does ring a bell. No, I've downloaded it but I haven't applied it.
>>
>>Thanks for the reminder.
>>
>>Peter
>
>Try delete tag all before appending, then rebuild the indices. It will be faster than updating the indices while appending the data.


You are correct, and I have used that trick at times. I even have a little function I call Tags_RS() which will generate the code necessary to rebuild the indexes.

But the main point here is that when the system is running the way it is capable of (over 600 appends per second) the whole 91,000 records can be loaded in less than 3 minutes. Fast enough that I don't need to bother with removing the indexes.

Peter
Peter Robinson ** Rodes Design ** Virginia
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform