Yes.Or, create two separate transactions and don't try to correlate them. Just make sure that the TX is snapshot isolation
On Mon, Jan 19, 2009 at 6:54 AM, Simone Busoli <[email protected]>wrote: > How would you deal with a single transaction which wraps the three crud > operations? Create a top level transaction in the pipeline executor? > > > On Mon, Jan 19, 2009 at 12:22 AM, Ayende Rahien <[email protected]> wrote: > >> Looks to be good. >> >> >> On Sun, Jan 18, 2009 at 5:09 PM, Simone Busoli >> <[email protected]>wrote: >> >>> It took me some time to find out a way to perform mirroring between two >>> tables, and I'm not sure what I've come up with is the best way. >>> Here's how I'm doing it: >>> >>> 1. Get all rows from source >>> 2. Get all rows from destination >>> 3. full outer join them on the primary key >>> 4. mark each row with flags "delete", "update", "insert" >>> 5. branch on these flags and send each group of rows to an operation >>> which either, deletes, updates or inserts on the destination table. >>> >>> Ideas? >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en -~----------~----~----~----~------~----~------~--~---
