db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Heap and stack size for Derby server
Date Fri, 03 Nov 2006 17:26:25 GMT
Bryan Pendleton wrote:
>> My problems came from a simple query containing an IN clause with 5000 
>> items in it. I went over this easily by increasing the stack size 
>> limit to 1024 KB.
> 
> Thanks Robert! That definitely sounds like DERBY-47. If you have the time,
> it'd be great to have some help in working on improving this part of Derby.

I don't think this is DERBY-47. DERBY-47 is the issue that the plan 
generated by an IN query is inefficient.

This issue is that a query with a large number of IN parameters fails to 
compile due to a stack overflow error.

Dan.



Mime
View raw message