Thanks Ilya, Denis.
Regards,
De : ilya.kasnacheev
Envoyé : mardi 5 juin 2018 18:15:45
À : user@ignite.apache.org
Objet : Re: Affinity colocation and sql queries
Hello!
1) Yes!
2) "almost all the time" is not a very strong constraint here. You mig
Hello!
1) Yes!
2) "almost all the time" is not a very strong constraint here. You might
need to enable distributed joins to get such (partially-collocated) queries
to perform. Your query might still benefit from collocation if query planner
realizes that all keys are located on the same node.
3)
Hi Stephane,
Affinity collocation and affinity keys are crucial concepts/APIs to make
SQL JOINs work really fast. Similar concepts are adopted in other
distributed databases like Google Spanner, MemSQL, VoltDB, etc.
This page should shed more light on your question:
https://apacheignite-sql.readm