I think 13s is still too much. Can you share a reproducer? Sergi
2017-04-10 9:51 GMT+03:00 afedotov <[email protected]>: > Hello, > > That is an expected behavior. On the first run a query is parsed and > metadata is built for it what takes some additional time compared to the > following runs. > > Kind regards, > Alex > > 10 апр. 2017 г. 8:13 AM пользователь "woo charles [via Apache Ignite > Users]" <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=11848&i=0>> написал: > >> Hi, >> >> I set up 3 Server nodes(8 cpu, 1gb ram) in the same server. >> 2 table each 10000 rows are entered. >> >> When I perform a *SQL Join* query on two table and run it 100 times, I >> found that the first query is much slower than other(i.e. First query used >> 13s & other used around 0.02s). >> >> Why will it happen? >> Can I reduce the running time on 1st query? >> >> >> ------------------------------ >> If you reply to this email, your message will be added to the discussion >> below: >> http://apache-ignite-users.70518.x6.nabble.com/Slow-on-1st- >> time-query-SQL-Join-tp11847.html >> To start a new topic under Apache Ignite Users, email [hidden email] >> <http:///user/SendEmail.jtp?type=node&node=11848&i=1> >> To unsubscribe from Apache Ignite Users, 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: Slow on 1st time query "SQL Join" > <http://apache-ignite-users.70518.x6.nabble.com/Slow-on-1st-time-query-SQL-Join-tp11847p11848.html> > Sent from the Apache Ignite Users mailing list archive > <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com. >
