Repository navigation
.eqJoin().group() is slower than .map().group() #6063
Description
I'm using the query profiler and getting these results with a big table:
eqJoin().group()
4.95s round-trip time
630ms server time
130 shard accesses
map(with subquery).group()
517ms round-trip time
180ms server time
24 shard accesses
These are after reruns to warm the cache. Is this normal?
Activity
danielmewes commentedon Aug 23, 2016
@thelinuxlich Is this on a cluster? How large is it? What are the sharding settings on the involved tables?
thelinuxlich commentedon Aug 23, 2016
It is a cluster with three machines, each table has 3 shards and 3 replicas