ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From afedotov <alexander.fedot...@gmail.com>
Subject Re: Query search performance and scalability
Date Thu, 04 May 2017 06:14:03 GMT
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]" <
ml+s70518n12401h65@n6.nabble.com> написал:

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
ml+s70518n1h65@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/Query-search-performance-and-scalability-tp12401p12407.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Mime
View raw message