My testing program: https://drive.google.com/open?id=0B_-zUEFkybdLcW5LR3RXZnJfOFE
It runs on linux system with 8cpu 24gb ram. 3 Server node(each 1 gb) are created. 20 set tables created(ie. 1 set table contain table Quote, StockInfo, BidAskBrokerQueue, PreviousQuote which mean 20*4 = 80 table created) Each table will insert 10000 records. After inserted data, sql join "select q.stock_id, q.price , s.symbol from Quote0.Quote as q, StockInfo0.StockInfo as s where q.stock_id = s.stock_id and q.stock_id = XXX" is perform. And about 13s is needed for the first sql query. 2017-04-10 14:53 GMT+08:00 Sergi Vladykin <[email protected]>: > 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-t >>> ime-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. >> > >
