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 <[email protected]>: > 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<?>> 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. >
