We are updating our records


Thanks Anandhi = b.cycle and b.site_id=44 and b.rel_cd in('code1','code2','code3') and b.groupid='123' 12,000 times?Even the idea create a temporary table holding only primary key and Column b, and then apply cursor to it is slow.There are one column in each table, call id, to link them.--For incremental/New data----- insert into A select * from B where column_name NOT IN (select column_name from B); --For Edited Data------- cursore C_AB select * from B minus select * from A For R in C_AB loop Update A set....where ...But the 2nd Where clause simply return the message of `more than one row is return', since the id is unpredictable and this create a `many to many' relationship in both tables.


I have another table B containg 10,000 records of incremented and edited records of A table.[email protected] update ( select upd.purchase_no u_pno, upd.amount u_a, 2 temp.purchase_no t_pno, temp.amount t_a 3 from upd, temp 4 where upd.urefitem = temp.urefitem ) 5 set u_pno = t_pno, u_a = t_a 6 / 635 rows updated.Is this time, 10 minutes for 12000 rows tables an acceptable (expected) time?I am using the following codes to append data from B to A.


Normally, I would try to use a single sql statment -- here, due to the "data being spread all over the place", and being distributed and all.I have a table named A containing say 100000 records.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>