My databases (mvstore) are growing rapidly, much more than I would expect based on the entered data. I also see CPU usage increasing.
Performing a DEFRAG reduces the database size significantly, sometimes by 60-70%. Running SCRIPT TO / RUNSCRIPT also has a similar effect. How can I identify what 'pollution' is consuming so much space? Browsing through the INFORMATION_SCHEMA has not provided any clues. We recently started using "CREATE MEMORY LOCAL TEMPORARY TABLE IF NOT EXISTS" more frequently. Could this be related to the problem? -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/4d828811-d255-415f-98ad-943c1255b8a4n%40googlegroups.com.
