Arjen Lentz wrote:
Yo Jim

On 07/08/2009, at 10:08 PM, Jim Starkey wrote:
 3. Before and after triggers for insert, update, delete, and commit

For some forms of auditing, triggers on SELECT?


It came up all the time. Still does on the Interbase lists. But nobody's come up with a proposal that seems useful for the purpose intended. The problem is when to consider a record read. Given effort, a record can be probed with a sequence of counts, for example, where not finding the record is almost as informative as finding it. Another problem is the shear volume of data produced.

So I'm not saying it can't be done, just that I haven't seen a good model yet.

--
Jim Starkey
Sent from Shearwater, off the coast of New England


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to