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,
RamIt 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.|||Update cursor may even slow down the process by locking rows