Subject Re: [firebird-support] Re: Newbie: Tracing all SQL statements
Author Martijn Tonies
Hi,

> Is there any plans to add this? Looking at the API there appears to
> be interceptable points of entry. It would be fairly straightforward
> to provide this facility perhaps as part of the database connection
> parameters.
>
> I am thinking in particular of something similar to the SQL Monitor
> that comes with Delphi Enterprise.

That SQL monitor hooks into to the BDE.

There are a couple of things here -

1) client side SQL monitoring

2) client side SQL monitoring for your application

3) server side SQL monitoring

Now, "2" is simple - most Firebird componentsets have some kind
of SQL monitoring component, but they hook only your application.

"1" should be possible as well - you should even be able to write
a "re-rout" dll if you like.

Personally, I think "3" is the coolest thing - together with quota etc
to see which queries are "heavy" on the server etc etc...

I don't know if "3" is being considered for Firebird 2 - but I guess
it is, along with many many other things.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com