-
Large Updates on SQL 6.5 - suggestions???
Hi,
I am new here and am hoping someone might have performance tuning suggestions for a large update I have to do.
I am updating 350,000 records on a 6.5 database and I am incrimenting them out 5,000 at a time. It took about 17 hours to complete the update!!!
Does this sound really off? Is there anything I can do to speed this up? I am doing a straight update. I am not specifying any cursor and am not using any temp tables... but I am doing it in a stored procedure. Any suggestions about what I can do better would be very much appreciated.
Thanks again.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|