Q: batch delete in an oltp environment ?

Sir, I have two tables. trans table contains unsettled transaction. archived table constain settled transaction. a batch process select from trans and settle them. after settlement, these rows will transfer to archived table by inserting into archive table and delete from trans table.
mass deletion settled transaction from trans table have performance impact on the incoming transaction(insert into trans).

Qestion, is there an alternative to this solution ?

thanks in advance
ted chyn

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 15:34:55 CST