Oh, also, during the difference in time, only 1-2 cores seem to be involved.
Mike From: Williams, Michael Sent: Monday, February 26, 2018 9:40 AM To: user@ignite.apache.org Subject: Slow Group-By All, Any advice on speeding up group-by? I'm getting great performance before the group-by clause (on a fairly decent size data set) , but adding it slows things down horribly. Without the group-by clause, the query takes about a minute, and all cores are fully in use. With the group-by cores, the query takes far longer. The only difference in the EXPLAIN plans appears to be the addition of the group-by clause. There are a lot of rows to be joined in the clause. Is there an equivalent to setQueryParallelism for this? Any things to try? Thanks, Mike
