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.