>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only