Valentin, Application knows that there is a cache with name "myCache" - this is a logical model. Cache "myCache" can be replicated or partitioned, it can be deployed to one ore more nodes - this is physical model. Application doesn't know physical model. It's only call cache.get(key), and ignite engine using metainfo and affinity functionality determines on wich node and partition the value is resides.
That's opportunity could be done for sql engine too (most likely it will require some revision of affinty's functionality). Is it now clear or still need examples with sql queries? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Sql-query-performance-with-partitioned-caches-tp2700p2718.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.