T
TheMadDBA
Guest
You almost never need to have that many records in a temp-table at one time. If you do then most likely something is wrong. Worst case when importing from a file you should be batching the temp-table load and then writing to the DB and emptying the temp-table. All that being said.... If you make sure your -Bt is set high enough to keep all of the temp-table records in memory and use EMPTY TEMP-TABLE it should happen pretty fast.
Continue reading...
Continue reading...