Re: [h2] Properly handling large result sets

2022-04-13 Thread Noel Grandin
MAX_MEMORY_ROWS is the one you want On Wed, 13 Apr 2022 at 16:12, Ron Exxon wrote: > I have a query that returns a very large result set, which gets overflowed > to disk in a size that is too large. The environment has ample memory to > handle this result set, however I haven't been able to find

[h2] Properly handling large result sets

2022-04-13 Thread Ron Exxon
I have a query that returns a very large result set, which gets overflowed to disk in a size that is too large. The environment has ample memory to handle this result set, however I haven't been able to find which configuration parameter controls the maximum in-memory size for a result set. I h