probably your queries are sufficiently large that they are generating temporary tables.
it is possible that the temporary tables are then leaking, we have had bugs like that in the past. you could try changing your queries, or playing with the MAX_MEMORY_ROWS setting, if you have a lot of free RAM, which changes the point at which H2 decides to switch from building the result set in memory, to storing it on disk. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
