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.fedot...@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. >