[Proxool-developer] Analyzing SQL Queries

[Kiran T <mah...@ho...>]

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 
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 
OnExecuteStart() and OnExecuteEnd(). If changing an existing public method 
in the Proxool API is a concern, can a new method be added and let the 
existing OnExecute() do the function of either start or end event?( I am 
assuming OnExecute() currently gets executed at the beginning of the query 
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/