RE: [Proxool-developer] Analyzing SQL Queries

[Bertrand R. <bre...@us...>]

There is an easier solution - just make use of the P6Spy JDBC driver... =
See
http://www.p6spy.com/

Just configure Proxool to use it instead of your actual database driver.

-bertrand


-----Original Message-----
From: pro...@li...
[mailto:pro...@li...] On Behalf Of =
Kiran T
Sent: mardi 1 juin 2004 22:28
To: pro...@li...
Subject: [Proxool-developer] Analyzing SQL Queries


Hello all,

In order to improve the efficiency of the website, I need to analyze all =
the

SQL Queries and find the top 10 slowest( in terms of time it takes to=20
complete execution)SQL queries. Is there a way to acheive this using =
Proxool

?

I remeber this being discussed few months ago.

One solution would be split the existing OnExecute() method into=20
OnExecuteStart() and OnExecuteEnd(). If changing an existing public =
method=20
in the Proxool API is a concern, can a new method be added and let the=20
existing OnExecute() do the function of either start or end event?( I am =

assuming OnExecute() currently gets executed at the beginning of the =
query=20
execution.)

If this is something that can be rolled out to 1.0, is there a temporary =

solution to tackle this issue?

Thanks all in advance.

Kiran T

_________________________________________________________________
Express yourself with the new version of MSN Messenger! Download today - =

it's FREE! =
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/



-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and =
evaluate
today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
Proxool-developer mailing list Pro...@li...
https://lists.sourceforge.net/lists/listinfo/proxool-developer