You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Pratham Joshi <pr...@vrhythmstech.com> on 2017/05/30 11:49:11 UTC
In Ignite 2.0.0 - cusrsor.getAll() takes very long time to retrieve
data.
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.
Re: Re[4]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to
retrieve data.
Posted by Sergi Vladykin <se...@gmail.com>.
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 <pr...@vrhythmstech.com>:
>
> 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.
>
Re[4]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to
retrieve data.
Posted by Pratham Joshi <pr...@vrhythmstech.com>.
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 | Skype : prathameshjoshi@outlook.com
------ Original Message ------
From: "alexey.goncharuk [via Apache Ignite Users]"
<ml...@n6.nabble.com>
To: "Pratham Joshi" <pr...@vrhythmstech.com>
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]
></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 | 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.70518.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data-tp13224.html
>>>><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.
>>>
>>>
>>>
>>>--------------------------------------------------------------------------------
>>>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
>>><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
><http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=13224&code=cHJhdGhhbWVzaGpAdnJoeXRobXN0ZWNoLmNvbXwxMzIyNHwtMTI4NTQ3NDI5>.
>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: 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 at Nabble.com.
Re: Re[2]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to
retrieve data.
Posted by Alexey Goncharuk <al...@gmail.com>.
What about the size of the result set returned?
2017-06-02 12:47 GMT+03:00 Pratham Joshi <pr...@vrhythmstech.com>:
> 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 | 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-
>> long-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.
>
Re[2]: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to
retrieve data.
Posted by Pratham Joshi <pr...@vrhythmstech.com>.
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 | Skype : prathameshjoshi@outlook.com
------ Original Message ------
From: "alexey.goncharuk [via Apache Ignite Users]"
<ml...@n6.nabble.com>
To: "Pratham Joshi" <pr...@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 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]
></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.70518.x6.nabble.com/In-Ignite-2-0-0-cusrsor-getAll-takes-very-long-time-to-retrieve-data-tp13224.html
>><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.
>
>
>
>--------------------------------------------------------------------------------
>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
><http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=13224&code=cHJhdGhhbWVzaGpAdnJoeXRobXN0ZWNoLmNvbXwxMzIyNHwtMTI4NTQ3NDI5>.
>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: 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 at Nabble.com.
Re: In Ignite 2.0.0 - cusrsor.getAll() takes very long time to
retrieve data.
Posted by Alexey Goncharuk <al...@gmail.com>.
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 <pr...@vrhythmstech.com>:
> 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.
>