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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/4d828811-d255-415f-98ad-943c1255b8a4n%40googlegroups.com.
