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 real time in memory fast query.Group by, top 100 are the 2 preferred queries. I need to get the figures great to put up a case, hence any help will be appreciated. Thanks and regards,
-- Indranil Basu On Wednesday 20 December 2017, 11:14:33 PM GMT+11, dkarachentsev <dkarachent...@gridgain.com> wrote: 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/