Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two loop or not to loop?
Message
De
02/09/2004 03:27:40
 
 
À
01/09/2004 14:56:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00938414
Message ID:
00938659
Vues:
21
Hi,

>>
I believe processing would be faster if you write to each file in turn.
Reason: the index file has to be updated for each record and more of the index could be cached.
I think the size of the tables and the .cdx is the main factor here, since the machine seems well equipped.
>>

FWIW, we've generally found it's faster to actually delete all non-required indexes before appending a large number of records then recreating them afterwards. Can't do that with a 'live' database of course...

Regards,
Viv
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform