Best value for parameter STACKSIZE

Hi, Recently, I have an error in one of the our instances: Assert Failed: Thread stack overflow detected. The origin was an extensive query with a lot of joins. I know that the parameter STACKSIZE is related to this error. I changed the default value 64 (for 64-bit), to 128. My question is: Are there any problem, according your experience, (apart from a increased memory consumption) with increasing this parameter to a higher value, for example 256 or 512, or 1024 ? Thanks.

Beyond the extra memory consumption per thread, no problem. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Nov 27, 2015 at 3:09 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote: > Hi, > > Recently, I have an error in one of the our instances: Assert Failed: > Thread > stack overflow detected. The origin was an extensive query with a lot of > joins. > > I know that the parameter STACKSIZE is related to this error. I changed the > default value 64 (for 64-bit), to 128. > > My question is: > Are there any problem, according your experience, (apart from a increased > memory consumption) with increasing this parameter to a higher value, for > example 256 or 512, or 1024 ? > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe51e00f36205258b4d71