Query performance varies in same kdb session

[Mahesh Panchal]

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

[Mahesh Panchal]

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

--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbpl...@googlegroups.com.
To post to this group, send email to personal...@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.

[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

On Friday, April 26, 2019 at 6:55:20 PM UTC+1, Mahesh Panchal wrote:

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

On Fri 26 Apr, 2019, 9:04 PM Hannah Robinson, <hjr18...@gmail.com> wrote:

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

On Friday, 26 April 2019 16:00:37 UTC+1, Mahesh Panchal wrote:

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

--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to personal...@googlegroups.com.