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.