Thread: updating queries?
View Single Post
  #1  
Old 02-09-2007, 04:18 AM
sizzer sizzer is offline
Junior Member
  
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sizzer is on a distinguished road
Default updating queries?
Hi all,
I am updating 2 tables with single query but it takes long to complete and lock the tables for long time. The other update queries are waiting for the lock to be released during this time. I am trying to do the time consuming update in iteration instead of waiting for long time to complete. Can someone suggest how to do this?
Thanks! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - updating queries?
Thread: updating queries?
View Single Post
  #1  
Old 02-09-2007, 04:18 AM
sizzer sizzer is offline
Junior Member
  
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sizzer is on a distinguished road
Default updating queries?
Hi all,
I am updating 2 tables with single query but it takes long to complete and lock the tables for long time. The other update queries are waiting for the lock to be released during this time. I am trying to do the time consuming update in iteration instead of waiting for long time to complete. Can someone suggest how to do this?
Thanks! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote