Re: Q: batch delete in an oltp environment ?

Sure, if the two tables have the same structure (or two structures that can be merged) you could use one merged table instead with a further flag indicating if this transaction is settled or not. You would then just update the flag but not move the data.

Martin

tedchyn_at_yahoo.com wrote:
>
> 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 Tue Feb 22 2000 - 19:56:12 CST