Re: configure pooling options to avoid BusyPoolException

2017-08-24 Thread Avi Levi
Thanks On Thu, Aug 24, 2017 at 6:23 PM, Michael Burman wrote: > Hi, > > You could try something like (I tried to cleanup the code from other stuff > in the gist-editor, so it might not compile directly) the following for > your scheduling: > >

Re: configure pooling options to avoid BusyPoolException

2017-08-24 Thread Michael Burman
Hi, You could try something like (I tried to cleanup the code from other stuff in the gist-editor, so it might not compile directly) the following for your scheduling: https://gist.github.com/burmanm/230c306f88c69c62dfe73799fc01 That should prevent pool getting full, instead using the

Re: configure pooling options to avoid BusyPoolException

2017-08-23 Thread Akhil Mehra
Since queries are asynchronously executed, you will need some mechanism in your code to queue your request. Try setting your setMaxQueueSize to meet your need. By default its 256

configure pooling options to avoid BusyPoolException

2017-08-23 Thread Avi Levi
Hi , I need to execute large amount (millions) of select queries. but I am getting BusyPoolExcption how can I avoid that ? I tried to configure the pooling options but couldn't see that it had any impact Any advice ? Failed to execute query SELECT * FROM my_table WHERE id = 'some_uuid' AND x >=