Hi Eugene, >For #2: wouldn't H2 need to bring the data into the heap to make the queries? > Or at least some of the date to do the group_by and sum operation?
yes, ignite will bring data from off-heap to heap, sometimes if data set is too big for heap memory you need to set lazy flag for your query: https://apacheignite-sql.readme.io/docs/performance-and-debugging#result-set-lazy-load Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
