Query performance varies in same kdb session

[maheshpanchal49]

Hi all,

When I try to run any query in that kdb service the query execution time varies every time .

Can you please guide me ?

Thanks in advance,

Mahesh

[Hannah_Robinson]

Hi Manesh, 

Would you be able to give an example of the queries you are running? The time taken for each query can vary depending on the amount of data in the database, how the database is partitioned and the attributes that are applied to the data. 

Further explanation of this is included in this whitepaper 

https://code.kx.com/v2/wp/kdb_query_scaling.pdf

Thanks,

Hannah

[maheshpanchal49]

Hi Robinson,

I am facing this issue for any statement i tried to execute even simple example like 1+1 or 2#trade.

I suspect some background activity putting this query in queue for execution but I'm not able to see those activities ,

Is there any tool to see all running activities or profiler ?

Thanks,

Mahesh

[TerryLynch]

Simon wrote some good tools for tracking usage of a server: https://code.kx.com/v2/kb/using-dotz/

This would tell you who is querying and when