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]" <[email protected]> написал: > 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 > [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> > -- View this message in context: 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 at Nabble.com.
