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

[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,
* CacheConfiguration<Long, MyClass> cfg = new CacheConfiguration<Long,
MyClass>();*

When I query data like 
*SqlFieldsQuery sql = new SqlFieldsQuery("select *  from MyTable where
field1<= some_value);
QueryCursor<List&lt;?>> cursor = cache.query(sql);
System.out.println(cursor.getAll().get(0));*

Now here *field1 *is an indexed field from MyClass(not the one I have used
as key) the cursor.getAll() operation takes very long time to retrieve the
result. 

I suppose that I am certainly missing some configuration, but couldn't
figure out what. 
Thanks in advance





--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data-tp13224.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.