Subject | Re: [firebird-support] Re: Newbie: Tracing all SQL statements |
---|---|
Author | Martijn Tonies |
Post date | 2003-10-09T10:08:24Z |
Hi,
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
> Is there any plans to add this? Looking at the API there appears toThat SQL monitor hooks into to the BDE.
> 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.
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