Versions des environnements
>Do the tables have indexes on them? If so, take them off and re-add them when the import is done. Importing the data and then adding the indexes can be significantly faster than just adding data to indexed tables.
>
>Also do you have the tables open exclusively? Having them open "shared" can slow down the import too.
yep they are indexed afterwards and open exclusive, I'm thinking about not using the memo fields and just storing references to where the data lies in the original files, then doing all the sort and match and simply using my fast file io routines to read and write direct to pipe delimited files based on the references in the resulting tables.
it's frustrating.
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