Hi Zaid, Also, note that only the first run takes longer than following runs since a query has to be parsed. In my environment, running the query from a client takes about 500 ms at first run and about 250 ms at following runs. >From a server, it takes 80ms and 10ms correspondingly. When running the query from client it mostly waits for a response from the server node.
On Thu, Mar 23, 2017 at 4:33 PM, Andrew Mashenkov [via Apache Ignite Users] <[email protected]> wrote: > Hi Zaid, > > It looks like you start query from client node, while cache data resides > on server node. > So, there is an overhead on data transfer from server node to client. > > I've simplified your test, but query return no records for me. > > On Fri, Mar 17, 2017 at 10:19 PM, Denis Magda <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=11392&i=0>> wrote: > >> Thanks, Zaid, >> >> One of Ignite SQL gurus will take a look at provided example and share >> suggestions. >> >> — >> Denis >> >> > On Mar 17, 2017, at 2:42 AM, zaid <[hidden email] >> <http:///user/SendEmail.jtp?type=node&node=11392&i=1>> wrote: >> > >> > Hi, >> > Please let me know if I need to provide anything else to reproduce the >> > issue. >> > Regards, >> > Zaid >> > >> > >> > >> > -- >> > View this message in context: http://apache-ignite-users.705 >> 18.x6.nabble.com/Very-slow-cache-query-compared-to-H2-tp11013p11268.html >> > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >> >> > > > -- > Best regards, > Andrey V. Mashenkov > > *SlowQuery.java* (9K) Download Attachment > <http://apache-ignite-users.70518.x6.nabble.com/attachment/11392/0/SlowQuery.java> > Regards, Andrew. > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://apache-ignite-users.70518.x6.nabble.com/Very-slow- > cache-query-compared-to-H2-tp11013p11392.html > To start a new topic under Apache Ignite Users, email > [email protected] > To unsubscribe from Apache Ignite Users, click here > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> > . > 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> > -- Kind regards, Alex. query_second_execution_time_visualvm.png (191K) <http://apache-ignite-users.70518.x6.nabble.com/attachment/11396/0/query_second_execution_time_visualvm.png> -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Very-slow-cache-query-compared-to-H2-tp11013p11396.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
