Process Design Question

[Mdavis123]

I have designed a process that has 4 stages that would run overnight on a server. There are about 4k new transactions every month added to about 256k current transactions.

Stage 1 -Check for any unyet processed transactions.
Sort/Update them into 3 different categories.
Reject those that are unsortable.

Stage 2,3,4
Run specific process for each of the three categories, including sorting by date and 2 other criteria.
using the newly updated category in the Where clause.

My question: Do I have to check that stage 1 has comitted all transactions before starting stage 2?

Thanks to all and Happy Hollidays
Mike D

 

[Durkin]

Hi. Not entirely sure what you mean but I think what you want is for each transaction to be processed as it completes stage 1 rather than fully completing stage 1 and then processing them all. If this is the case then you could try putting your secondary stages into triggers.

Durkin