* >>>* This Scan/Replace takes .013 seconds >>>* --------------------------------- >>>select 0 >>>use bsmemo order k_seqno >>>select 0 >>>use jmemo alias c_memo exclusive >>>* >>>msec = seconds() >>>* >>>select c_memo >>>scan for updtflag = 'U' >>> select bsmemo >>> if seek(c_memo.k_seqno) >>> replace textln with c_memo.textln >>> endif >>>endscan >>>* >>>? seconds() - msec >>>* >>>* >>>* This SQL Update takes 16 seconds >>>* --------------------------------- >>>msec = seconds() >>>* >>>update bsmemo set ; >>>textln = c_memo.textln ; >>>from c_memo ; >>>where c_memo.k_seqno = bsmemo.k_seqno ; >>>and c_memo.updtflag = 'U' >>>* >>>? seconds() - msec>>
>>msec = seconds() >>* >>update bsmemo set textln = c_memo.textln ; >>from c_memo join bsmemo on c_memo.k_seqno = bsmemo.k_seqno ; >>where c_memo.updtflag = 'U' >>* >>? seconds() - msec >>>