proxool-developer

[Proxool-developer] Query execution time

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

Hello all,
Does proxool support, directly or indirectly, determining the execution time 
for each query?

For any given connection, I can get the total time by tracking the time 
taken between getting the connection out of a pool and dumping back to the 
pool but a single connection can have  multiple queries associated with it.

Does onExecute() event triggered at the beginning or the end of execution?

Thanks in advance
Kiran

_________________________________________________________________
Check out the new MSN 9 Dial-up — fast & reliable Internet access with prime 
features! http://join.msn.com/?pgmarket=en-us&page=dialup/home&ST=1

Re: [Proxool-developer] Query execution time

[Bill H. <bi...@lo...>]

Hi Kiran,

On Mon, 2004-01-26 at 20:13, Kiran T wrote:

> Does proxool support, directly or indirectly, determining the execution time 
> for each query?

Yep. Use the ConnectionListenerIF.

> Does onExecute() event triggered at the beginning or the end of execution?

At the end. Although I seem to remember someone else asking for another
event at the beginning of execution too.

onExecute() conveniently passes you the elapsed time for each execution.

It doesn't take account of the time taken to fetch any information from
a Connection, however. For instance, iterating through a large ResultSet
or reading a large Clob.

- Bill