August 4, 2004 at 5:54 am
Hello!
I ran into one strange thing about DTS. I selected a copy four tables from one database to another one in the same server. One for these tables has 1 mill items in it. I selected the append method cause it was just going to append new items and shouldn't touch the other. The problem is that it take five minutes or so to do it. Why does it take som long? If this rise to 10 or 100 mill - how long time will that take?
What can I do that to make it faster?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
August 4, 2004 at 6:04 am
If you find that as DTS is running, it transfers a batch of rows quickly, then pauses for a while, then transfers another batch of rows quickly, then pauses for a while etc... then the problem is that you need to expand the size of your database. Most databases default to increasing datafile size by 10%. Change this to increase by X MB or X % whatever, according to the amount of data you are adding and you will see a massive speed increase. (if you are seeing the pausing that I described)
Dave Hilditch.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply