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