Archives of the TeradataForum
Message Posted: Tue, 27 May 2008 @ 15:40:26 GMT
IIUC this is a pretty standard enqueue/dequeue strategy and should work OK.
Another approach, depending on the transaction integrity completeness requirements, would be to serialize the small table updates through a queue table: that is, insert the updates into a queue table, and then have a single "SELECT AND CONSUME" statement paired with an UPDATE into the final target table. One can use a stored procedure for this.
This will serialize the updates for the small table without holding-up the rest of the transaction(s).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|