Denis,
Thanks very much!
All data are related ,and there are about 60G data in the heap. And if I
add other business module ,the data also are related.We can not split them.
So If data is collocated, then a single node is enough. But it's not high
availability.
At 2017-12-06 18:06:05, "Denis Mekhanikov" <[email protected]> wrote:
Looks like you ran this query on a cluster with more than one node, so you get
performance drop because of distributed joins.
Let's tune performance on a single node first. You can expect queries with
joins to operate fast only if data is collocated.
Otherwise latency will suffer from network communication.
So, what is performance and plan of query execution on a single node?
Denis
