Indeed, a very usefull advice! Thanks for sharing.

Regards,

Fabiano

On Mon, Sep 14, 2009 at 12:19 AM, Alan McDonald <alan@...> wrote:
> Here's a helpful hint for anyone thinking of using the $MON tables
> seriously.
> I've just spent a few days monitoring with sinatica monitor and find that a
> most helpful thing you can start doing now for any future work in this area
> is to insert a comment line into the SQL of every query you issue against
> the server. Something which will allow you to find that exact statement in
> your code.
> I have now frequently jumped from transaction to statement and user and then
> found the SQL I need to work on (e.g. change a transaction isolation etc)
> but would have been able to locate the code in my application much faster
> had I placed SQL code like this:
>
> SELECT
>  /*my_query_component_name and or form_name */
>    FIELD1
>  , FIELD 2
>  etc
> FROM TABLE
>
> I could then have done a GExperts search on this comment line and jumped
> straight to the place I needed.
> Maybe many of you already do such a thing but for those who don’t it's worth
> doing now.
>
>  regards
>  Alan McDonald
>
>
>
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>