Hi, It isn't a good idea to update millions of items every time product details are changed.
I guess the main purpose of this schema is to store product details close to items. I suggest you add an additional cache for product details and make it replicated. It seems that products count is much less than the items one. Another way is configuring the affinity collocation [1]. You can specify indexes and use SQL to merge items data with product details [2]. It is going to work fast and you don't need to update millions of items every time product details are changed. Will it work for you? Best Regards, Roman [1] https://apacheignite.readme.io/v2.3/docs/affinity-collocation [2] https://apacheignite-sql.readme.io/docs/distributed-joins#section-collocated-joins -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
