Information générale
Catégorie:
Codage, syntaxe et commandes
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement