Hi, You can try to increase SqlQuery.setTimeout() (30 sec by default) or connectorConfiguration.setIdleTimeout() (7 sec by default) It may slightly help if you use sorting, as you need to have pages of rows from all nodes to make correct merge.
Also, you can try to increase SqlQuery.pageSize() or JDBCStatement.fetchSize(). 1024 is default value. On Wed, Apr 26, 2017 at 3:24 PM, neerajbhatt <[email protected]> wrote: > Hi All > > We have a cache which is to be partitioned across nodes. > Currently all the SQL queries are executed on all nodes by default. > However, if a node is slow, all the queries will be slow. > So, is there a way to set the timeout on the SQL queries, so that even > though a few nodes are slow and timeout, the data is returned from rest of > the nodes. > This way, we will get partial data, instead of exception. > > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/setting-query-timeout-and-getting- > partial-result-instead-of-exception-tp12266.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Andrey V. Mashenkov
