Re: Slow Updates on Memory table - (detailed) - ANYONE??

[B L]

update TDRV2_7_7 set TDR_ECCID='abcd', TDR_ACTUALESN=5 where TDR_TRANSACTIONID=1
23 and TDR_CREATIONDATE_EPOCH=0000 and TDR_CREATIONDATE_NANO=0000;
update TDRV2_7_7 set TDR_ECCID='abcd', TDR_ACTUALESN=5 where TDR_TRANSACTIONID=1
23 and TDR_CREATIONDATE_EPOCH=0010 and TDR_CREATIONDATE_NANO=0010;
update TDRV2_7_7 set TDR_ECCID='abcd', TDR_ACTUALESN=5 where TDR_TRANSACTIONID=1
23 and TDR_CREATIONDATE_EPOCH=0050 and TDR_CREATIONDATE_NANO=0050;

(these statements were auto-generated from a shell script, that's why there are leading zeros. Shouldn't affect anything)

Keep in mind that the DB is VERY fast at finding the records, but very slow in actually updating them.