First of all, it would be a good idea to collocate data in your caches, i.e. make items be stored on the same nodes with corresponding products. Take a look at the documentation: https://apacheignite.readme.io/docs/affinity-collocation#collocate-data-with-data <https://apacheignite.readme.io/docs/affinity-collocation#collocate-data-with-data>
When you need to update some product, you can perform an affinityRun <https://apacheignite.readme.io/docs/affinity-collocation#section-collocating-compute-with-data> , that will send a task to the node, where the corresponding product data is stored. In that affinity run you can perform a local query <https://apacheignite-sql.readme.io/docs/local-queries> , that will update all needed items. In these settings you will execute the query on a single node only. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
