Hi Vinokurov, I was thinking to use Java ExecutoreService to submit the task (task to invoke CacheStore.loadCache method). Is it ok to use ExecutorService or ignite provides some way to submit the task?
Thanks, Prasad On Fri, Feb 9, 2018 at 6:04 PM, Vinokurov Pavel <vinokurov.pa...@gmail.com> wrote: > Hi Prasad, > > Within your implementation of CacheStore.loadCacheYou you could use > multiple threads to retrieve rows by batches. > Note that each thread should use different jdbc connection. > > 2018-02-09 13:57 GMT+03:00 Prasad Bhalerao <prasadbhalerao1...@gmail.com>: > >> Hi, >> >> I have multiple oracle tables with more 50 million rows. I want to load >> those table in cache.To load the cache I am using CacheStore.loadCache >> method. >> >> Is there anyway where I can load a single table in multithreaded way to >> improve the loading performance? >> What I actually want to do is, >> 1) Get all the distinct keys from the table. >> 2) Divide the list of key in batches. >> 3) Give each batch of keys to a separate thread which will fetch the data >> from the same table in parallel mode. >> e.g. Thread T1 will fetch the data for key 1 to 100 and thread T2 2ill >> fetch the data for keys 101 to 200 and so on. >> >> Does ignite provide any mechanism to do this? >> >> Note: I do not have partitionId in my table. >> >> >> Thanks, >> Prasad >> > > > > -- > > Regards > > Pavel Vinokurov >