I'm not able to reproduce the timings you specified. Probably I do something wrong. Could you please provide a log for that case? Also, it would be of great help if you provide the reproducer sources.
Kind regards, Alex. On Tue, Apr 11, 2017 at 4:57 AM, woo charles [via Apache Ignite Users] < ml-node+s70518n1187...@n6.nabble.com> wrote: > 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 <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=11870&i=0>>: > >> I think 13s is still too much. Can you share a reproducer? >> >> Sergi >> >> 2017-04-10 9:51 GMT+03:00 afedotov <[hidden email] >> <http:///user/SendEmail.jtp?type=node&node=11870&i=1>>: >> >>> 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. >>> >> >> > > > ------------------------------ > 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-tp11847p11870.html > To start a new topic under Apache Ignite Users, email > ml-node+s70518n1...@n6.nabble.com > 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-tp11847p11889.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.