1. Looks like you are measuring something wrong. Most probably query execution takes longer than 1 ms.
2. I guess in your case it is better to have a descending index on field1. Sergi 2017-06-02 15:49 GMT+03:00 Pratham Joshi <[email protected]>: > > In some cases its 100K or it may be only 1 in few cases. > In fact I have tried to append *limit 1 *to my query so that only one > record will be fetched in any case but no improvements there also. > > Thank you, > Prathamesh Joshi. > Mob : +91 9960414777 <+91%2099604%2014777> | Skype : [hidden email] > <http:///user/SendEmail.jtp?type=node&node=13344&i=0> > > > > ------ Original Message ------ > From: "alexey.goncharuk [via Apache Ignite Users]" <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=13344&i=1>> > To: "Pratham Joshi" <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=13344&i=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 12:47 GMT+03:00 Pratham Joshi <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=13341&i=0>>: > >> Yes, I have used *@QuerySqlField(index = true)* in MyClass. And here's >> my query plan using explain. >> >> ============== Start time ===== 2017-06-02 15:11:45.*454* >> ***Query executed === >2017-06-02 15:11:45.*455* >> [SELECT >> __Z0.FIELD1 AS __C0_0, >> __Z0.VALUE2 AS __C0_1 >> FROM "Test_CacheConfig".MYCLASS__Z0 >> /* "Test_CacheConfig".INDEXGRP1: MINIPVAL <= ?1 */ >> WHERE __Z0.FIELD1<= ?1] >> [SELECT >> __C0_0 AS MINIPVAL, >> __C0_1 AS NETWORK >> FROM PUBLIC.__T0 >> /* "Test_CacheConfig"."merge_scan" */] >> >> Seems like query only takes 1 ms. But the when I fetch results from >> cursor.getAll() it is taking 100 ms to 1 sec. >> >> >> Thank you, >> Prathamesh Joshi. >> Mob : +91 9960414777 <+91%2099604%2014777> | Skype : [hidden email] >> <http:///user/SendEmail.jtp?type=node&node=13336&i=0> >> >> >> >> ------ Original Message ------ >> From: "alexey.goncharuk [via Apache Ignite Users]" <[hidden email] >> <http:///user/SendEmail.jtp?type=node&node=13336&i=1>> >> To: "Pratham Joshi" <[hidden email] >> <http:///user/SendEmail.jtp?type=node&node=13336&i=2>> >> 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 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 <[hidden email] >> <http:///user/SendEmail.jtp?type=node&node=13335&i=0>>: >> >>> 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.705 >>> 18.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-l >>> ong-time-to-retrieve-data-tp13224.html >>> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >>> >> >> >> >> ------------------------------ >> If you reply to this email, your message will be added to the discussion >> below: >> http://apache-ignite-users.70518.x6.nabble.com/In-Ignite-2- >> 0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data- >> tp13224p13335.html >> To unsubscribe from In Ignite 2.0.0 - cusrsor.getAll() takes very long >> time to retrieve data., click here. >> NAML >> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >> >> >> ------------------------------ >> View this message in context: Re[2]: In Ignite 2.0.0 - cusrsor.getAll() >> takes very long time to retrieve data. >> <http://apache-ignite-users.70518.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data-tp13224p13336.html> >> >> Sent from the Apache Ignite Users mailing list archive >> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com. >> > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://apache-ignite-users.70518.x6.nabble.com/In-Ignite- > 2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve- > data-tp13224p13341.html > To unsubscribe from In Ignite 2.0.0 - cusrsor.getAll() takes very long > time to retrieve data., click here. > NAML > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > > ------------------------------ > View this message in context: Re[4]: In Ignite 2.0.0 - cusrsor.getAll() > takes very long time to retrieve data. > <http://apache-ignite-users.70518.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data-tp13224p13344.html> > > Sent from the Apache Ignite Users mailing list archive > <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com. >
