Hello! SqlFieldsQuery does not have connection pool limit, since it is handled by GridGain nodes and it is multiplexed asynchronously.
The actual SQL request handling takes place in query thread pool, which indeed has default size of max(8, total number of cores) Regards, -- Ilya Kasnacheev ср, 17 мар. 2021 г. в 14:12, swara <[email protected]>: > Thank you for your response. > > Based on your analysis we figured out that there is a cursor close issue. > On > a related note could you please suggest on What is the default connection > pool limit for running queries using SqlFieldsQuery? > > Does it depend on the number of cores alone? > If we have 8 core processor then how many connections will we get to > ignite, > is there a way to increase the pool size to 100 as we have many users using > the ignite for join queries? > > By referring > > https://ignite.apache.org/docs/latest/perf-and-troubleshooting/thread-pools-tuning > > /The default pool size is max(8, total number of cores). Use > IgniteConfiguration.setQueryThreadPoolSize(…) or a similar API from your > programming language to change the pool size./ > > Thank You > Swara > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
