Any Alternative for SELECT... FOR UPDATE query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Any Alternative for SELECT... FOR UPDATE query

  1. #1
    Join Date
    May 2006
    Posts
    17

    Any Alternative for SELECT... FOR UPDATE query

    Hi Everyone,
    In my application I am using SELECT...FOR UPDATE query due to which the CPU utilization is shooting up very fast. Could someone please chip in with some good alternative for the SELECT...FOR UPDATE query so that the CPU utilization could be brought down.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you actually determined the cause of the cpu shooting up fast?

    if you need to lock the record then you are kind of stuck with it arent you

  3. #3
    Join Date
    May 2006
    Posts
    17
    yes you are correct...we need to lock the record for updation.
    Various factors have been identified for the high CPU utilization and this query is one of the factors.

  4. #4
    Join Date
    May 2006
    Posts
    17
    Actually we need to cut down the CPU utilization.......and definitely SELECT...FOR UPDATE query consumes a lot of CPU. So i need to know can we replace SELECT...FOR UPDATE with any other logic.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Locking the row won't consume much CPU. It's the SELECT statement itself that will do that. Start by tuning that as you would any other query.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width