Re: Re[4]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data.

2017-06-02 Thread Sergi Vladykin
uot; <[hidden email] > <http:///user/SendEmail.jtp?type=node=13344=2>> > Sent: 6/2/2017 6:06:38 PM > Subject: Re: Re[2]: In Ignite 2.0.0 - cusrsor.getAll() takes very long > time to retrieve data. > > What about the size of the result set returned? > > 2017-06-02

Re[4]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data.

2017-06-02 Thread Pratham Joshi
-- Original Message -- From: "alexey.goncharuk [via Apache Ignite Users]" <ml+s70518n13341...@n6.nabble.com> To: "Pratham Joshi" <prathame...@vrhythmstech.com> Sent: 6/2/2017 6:06:38 PM Subject: Re: Re[2]: In Ignite 2.0.0 - cusrsor.getAll() takes very long tim

Re[2]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data.

2017-06-02 Thread Pratham Joshi
.nabble.com> To: "Pratham Joshi" <prathame...@vrhythmstech.com> Sent: 6/2/2017 2:58:47 PM Subject: Re: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data. >How do you configure field1 to be an indexed field? Do you use >@QuerySqlField annotation? Can y

Re: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data.

2017-06-02 Thread Alexey Goncharuk
How do you configure field1 to be an indexed field? Do you use @QuerySqlField annotation? Can you share the execution plan of your query (you need to run "explain select ..." query)? Also, what is the result set size of your query? --AG 2017-05-30 14:49 GMT+03:00 Pratham Joshi

In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve data.

2017-05-30 Thread Pratham Joshi
Hello Guys, I am using Ignite 2.0.0 with Oracle database while. By implementing CacheStore I store put data in the cache. I am having geolocation and IP data almost 35m rows. I use id from DB row as key and corresponding row as the value of CacheConfiguration. Like, *