Re: Group By Query is slow : Apache Ignite 2.3.0

Hi, Were you able to resolve the issue? If yes, it would be nice to share it with the community. D. On Thu, Dec 21, 2017 at 12:49 AM, dkarachentsev wrote: > Hi Indranil, > > These measurements are not fully correct, for example select count(*) might > use only

Re: Group By Query is slow : Apache Ignite 2.3.0

Hi Indranil, These measurements are not fully correct, for example select count(*) might use only index and in select * was not actually invoked, because you need to run over cursor. Also by default query is not parallelized on one node, and scan with grouping is going sequentially in one

Re: Group By Query is slow : Apache Ignite 2.3.0

Hi,     There are 86486 records.   Time taken for select count(*) from A => 35 ms Time taken for select mainId, count(*) from A group by mainId => 70 ms Time taken for select * from A => 0 ms  I am doing a POC with apache ignite and I am very keen to use it in production for live streaming and

Re: Group By Query is slow : Apache Ignite 2.3.0

Hi, How many records your query returns without LIMIT? How long does it take to select all records without grouping? Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Group By Query is slow : Apache Ignite 2.3.0

Hi Dmitry,    I have only 1 node at this moment. The way I am measuring is using stop watch kind of stuff before and after execution of the sql query. This is the only query and I kept it running in a while loop with some sleep so that JIT compiler has done all its optimisation. Please fine

Re: Group By Query is slow : Apache Ignite 2.3.0

Hi, How many nodes do you have and how do you measure that 70 ms? Is it first query or average time? Please show your EXPLAIN of the query. Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Group By Query is slow : Apache Ignite 2.3.0

Hi,     I am trying to execute a group by query on 86k items in a cache which is taking 70 ms which imo is quite slow Can anyone please let me know what is that I may be doing wrong? Model code: @Data @ToString @QueryGroupIndex.List(@QueryGroupIndex(name = "idx1")) public class A implements