Subject Re: [firebird-support] Database level sql monitor?
Author Harri Vartiainen
On Thu, Dec 4, 2008 at 1:01 AM, Alexandre Benson Smith
<iblist@...> wrote:
> If you use FB 2.1 you could use the monitoring tables for this,
> Just a reminder...
> Monitoring tables are a snapshot on a given moment, so you have no way
> to catch all statements executed, you will get as much as you ask for,
> even if you ask every 0.5 seconds you will miss some quick queries.

Polling would probably miss most of queries.. Is it possible to add
trigger to monitoring tables to store running queries to different
logging table? Or would it cause infinite loop..