Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: cursor and update

    Hi,

    I have a table t1 (part_id int, gen_code int) part_id is a primary key.

    I have a cursor on t1 for part_id , I take part_id
    go thro different tables , do calculations and update gen_code for that part_id in t1 . This process is very slow and I see waittype 'LATCH_EX' and 'CXPACKET' all the time in process info .


    do I have to declare cursor for update? how does it diff from read_only cursor.

    please reply how do I make this process faster.


    thanks,
    Ram

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: cursor and update

    It would be helpful if you woul dexplain your process in more detail. Otherwise, it's even for a guru difficult to look into a crystal ball.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Hi

    Update cursor may even slow down the process by locking rows

Posting Permissions

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