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.

Reply via email to