ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dkarachentsev <dkarachent...@gridgain.com>
Subject Re: Group By Query is slow : Apache Ignite 2.3.0
Date Thu, 21 Dec 2017 07:49:27 GMT
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 thread.

Try to recheck your results on one node with enabled query parallelism:
CacheConfiguration.setQueryParallelism(8) [1]. 

And/or on 4 server nodes with 1 backup. You should get better numbers
because of spreading query over machines.

[1]
https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration/CacheConfiguration.html#setQueryParallelism(int)

Thanks!
-Dmitry



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Mime
View raw message