measuring query performance

Community Support
1

Hi,
I currently use \t to measure time taken by a query/ block of code in milliseconds. Is there any way to measure in micro/nano seconds?

Regards

2

Repeat it 1000 times. Divide the time by 1000.

\t:1000 til 100000

3

Hi Yan,

If I need to execute an expression once and need to measure the time then I need to write it like..

\t <q expression to execute>\t log til 1000

But if I need to execute the expression n times and measure the time then I need to write it like 

\t:<n times><q expression>\t:1000 log til 1000

am I correct?

thank you.

4

yes

5

Yes you are right.

From 

http://code.kx.com/wiki/Reference/SystemCommands#.5Ct_.5Bp.5D_-_timer

q)\t log til 100000 / milliseconds for log of first 100000 numbers3q)\t do[100;log til 100000] / timing for 100 repetitions196q)\t:100 log til 100000 / timing for 100 repetitions, new syntax of "\t:n expr" since 3.0 2011.11.22186