Re: Scaling with SQL query

2018-06-27 Thread Tom M
Hi Dmitry,   Another question. I am curious if I query via JDBC or new thin client, will the reduce happen on one of server nodes serving as a proxy?   Sent: Thursday, June 28, 2018 at 2:02 PM From: "Tom M" To: user@ignite.apache.org Subject: Re: Scaling with SQL query

Re: Scaling with SQL query

2018-06-27 Thread Tom M
Hi Dmitry,   Thanks for the great explanation!   Looks like "reduce" hapenning on the client is the issue that can be solved with adding clients.   Sent: Wednesday, June 27, 2018 at 6:22 PM From: dkarachentsev To: user@ignite.apache.org Subject: Re: Scaling with SQL query Hi, Slight degr

Re: Scaling with SQL query

2018-06-27 Thread Tom M
on overheads caused by  that the "reduce" node collects data from multiple nodes. Please show metrics for this query for you configuration.   Thanks, Pavel     2018-06-26 6:24 GMT+03:00 Tom M <tar...@mail.com>: Hi,   I have a cluster of 10 nodes, and a cache with replica

Scaling with SQL query

2018-06-25 Thread Tom M
Hi,   I have a cluster of 10 nodes, and a cache with replication factor 3 and no persistency enabled. The SQL query is pretty simple -- "SELECT * FROM Logs ORDER by time DESC LIMIT 100". I have checked the index for "time" attribute is applied.   When I increase the number of nodes, throughpu