db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Timing code in Derby
Date Fri, 27 May 2005 07:32:57 GMT
That information can be seen using system procedures to get runtime
statistics. You can set statistics gathering using
SYSCS_SET_RUNTIMESTATISTICS() and get the statistics gathered after a
query is executed using SYSCS_GET_RUNTIMESTATISTICS(). There should be
more info about these in Derby manuals or you can check out some test
cases in 'lang' test directory.


Shreyas Kaushik wrote:

> Hi all,
>   I have seen code like the following lines in many places in Derby code.
>  *beginTime = getCurrentTimeMillis()*  and  *openTime +=
> getElapsedTime(beginTime).
> *
> I presume these methods are used to calculate the time taken to
> perform some operation like a fetch, open, etc. Is this information
> stored anywhere in the logs ? I could not see this anywhere. Is there
> something extra ( a parameter setting or some properties file) that
> needs to be done to enable this and see the results?
> ~ Shreyas

View raw message