August 28, 2002 at 3:00 pm
I need to updated a large amount of rows remotely using ADO. Right now I am using a disconnected recordset, then using batchupdate...but it takes forever...
I need to update about about 1 million records at a time.
What options do i have to speed this up?
August 28, 2002 at 5:03 pm
The biggest areas of slowdown are with indexes. If you can script out your non-clustered indexes unless your primary key is one of them, drop them and recreate when done. Overall may go faster, depedning on the size of the database. Beyond that locks on the database issue with the batch update may be slowing you down as well. You may want to try smaller batches as well. Can you give abit of detail what you are doing and trying to accomplish.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 28, 2002 at 5:12 pm
ADO (or any operation for that matter) with a million rows at a time is going to hurt, even with a relatively small row size. Are tools like DTS an option?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply