Hi Kyriako, Agree with Nikolai on both points.
Regarding point number 2, you want to use affinity data / data colocation and data / compute colocation. You basically need to ensure that when you are inserting data into the cache you use the same affinity for all entries that need to be collocated to ensure they end up on the same server. Then you can use an affinity run or broadcast with local query enabled to only execute the query locally. Now in your case you said the data is in an external database so I’m not sure how you would ensure the data for each query is local. Christos > On 5 Apr 2017, at 11:00, kmandalas <kyriakos.manda...@iriworldwide.com> wrote: > > Hello Nikolai, all > > About 1: yes, this was my perception as well, thanks for the confirmation > > About 2: Even if all the nodes provide result sets of local execution to the > query initiator, if we are talking about results being Lists containing a > couple of thousands POJOs, then wouldn't be a big overhead these objects to > be transferred over the Network? At least from some tests I perform, the > response time is worse than querying the DB directly. Is there a way I make > sure each node has all the data that will query locally? In combination with > Compute Task Adapter always. > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Distributed-Closures-VS-Executor-Service-tp11192p11739.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com.
