ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jessie Lin <jessie.jianwei....@gmail.com>
Subject Re: Query search performance and scalability
Date Thu, 04 May 2017 16:35:28 GMT
Alex, thanks for reply.
The query is fairly simple, colA =?
colA is String.
For 1 server 1 client scenario, they are the same server.
For 2 server 1 client scenario, one server and client are on one server,
the other server node is on another server.
Working on a simplified code to reproduce the problem to share with you

Jessie


On Wed, May 3, 2017 at 11:14 PM, afedotov <alexander.fedotoff@gmail.com>
wrote:

> That should be because of the overhead of network roundtrips between the
> client and the servers. Are servers and client located on the same physical
> machine?
> Please provide the query and cache config.
>
> Kind regards,
> Alex
>
> 4 мая 2017 г. 3:36 AM пользователь "waterg [via Apache Ignite Users]"
<[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=12407&i=0>> написал:
>
> I have a program that issues SQLQuery on colA, colA has a single column
> index.
> The cache has about 360K entries, and 298K unique values in colA.
> I ran the query 1M times with different values.
>
> If the cache only has cache key, here's the results I ran with three
> senario
> With 1 server node: average search time is 35K nanosecs
> With 1 server – 1 client: average search time is 128K nanosecs
> With 2 server – 1 client: average search time is 276K nanosecs
>
> If the cache has Affinity Key, here's the results I ran with three senario
> With 1 server node: average search time is 59K nanosecs
> With 1 server – 1 client: average search time is 148K nanosecs
> With 2 server – 1 client: average search time is 287K nanosecs
>
> Could anyone advise why the search speed degrades as more nodes are added?
> Thank you!
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://apache-ignite-users.70518.x6.nabble.com/Query-search-
> performance-and-scalability-tp12401.html
> To start a new topic under Apache Ignite Users, email [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=12407&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: Query search performance and scalability
> <http://apache-ignite-users.70518.x6.nabble.com/Query-search-performance-and-scalability-tp12401p12407.html>
>
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>

Mime
View raw message