Re: Track all records read from a table

[Booth Martin <booth@xxxxxxxxxxxx>]

As I understand it, a read trigger is pulled with CPYF and normal 
back-up. That could be a serious impact on some files and would be a big 
concern that should not be ignored.  In my opinion.

On 3/21/2016 8:03 AM, Jim Oberholtzer wrote:
> Excellent point.  (I do think you meant firing trigger rather than
> journaling will slow it down though)
>
> Additionally to mitigate the effect of the trigger, when your read trigger
> fires, have it do nothing but enqueue a data queue entry with the needed
> information then quit.  That way it's very fast, and any database activity
> would not be impacted.  Your program that reads the data queue and does
> whatever it has to do can then do it in a more leisurely way.
>
> --
> Jim Oberholtzer
> Agile Technology Architects