Can you please advise, which SQL group-by query would be better practice, perform better?
(1) *select A, B, SUM(C) from MyCache where MyCache.id IN (....................) group by A, B* or, (2) by first storing IDs to be joined into some temporary cache as setting ID as affinity key to co-locate the data with MyCache and then do a cross-cache join query as the following; *select A, B, SUM(C) from MyCache, TempCache where MyCache.id = TempCache.id group by A, B* (1) or (2) ? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-Aggregation-query-tp4968p4974.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
