Hi Noel, thanks for your reply. We tried to increase the value of MAX_MEMORY_ROWS, but unfortunately there is no change. We noticed that the file .db grows even when we simply drop a view.
Any idea? Many thanks Il giorno lunedì 10 luglio 2017 21:48:13 UTC+2, Noel Grandin ha scritto: > > 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.
