[h2] Properly handling large result sets

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

Re: [h2] H2 DB Temp File is created on separate drive

Thanks! That's exactly what I needed. On Wednesday, February 2, 2022 at 1:26:10 PM UTC-6 Noel Grandin wrote: > You'd have to modify how the java VM chooses where to put temporary files. > There are various ways to do that depending on how you want to control it, > but at minimum it would have t

[h2] H2 DB Temp File is created on separate drive

I am using an embedded H2 DB (v2.1.210) in a Windows Server 2016 environment. I have the database configured to use a jdbc URL with a relative path from a location on the D: drive (jdbc:h2:../data). I have a query with a large result set that seemed to be hanging. Upon further investigation, i f