Discussion on:

Message 2 of 2
0 Votes
+ -
So what sort of overhead does this add?
I can see it being slightly faster than an old style trigger solution, and certainly less maintenance.

What happens if you alter the table to add/drop a column as well.

Course my big problem would be down to supporting across multiple DBMS's so I'd probably end up continuing to use triggers or I'd have to make any existing data change capture look like it had been produced by this. A little less coupling would have been nice.

I also have this intimation of doom where people forget to run the clean up and run out of disk space. sad
Posted by Tony Hopkinson
Updated - 29th Jul 2009