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 below the explain plan:
[[SELECT
__Z0.MAINID AS __C0_0,
COUNT(*) AS __C0_1
FROM "testcache".A __Z0
/* "testcache".A_MAINID_IDX */
GROUP BY __Z0.MAINID], [SELECT
__C0_0 AS MAINID,
CAST(SUM(__C0_1) AS BIGINT) AS __C0_1
FROM PUBLIC.__T0
/* "testcache"."merge_scan" */
GROUP BY __C0_0
LIMIT 20]]
Thanks and regards,
-- IB
On Wednesday 20 December 2017, 1:06:51 AM GMT+11, dkarachentsev
<[email protected]> wrote:
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/
