paypal.me/yusufwelding Pada Minggu, 09 Juni 2024 pukul 04.20.34 UTC+7 Andrei Tokar menulis:
> > Plaese see nice recent message here > <https://github.com/h2database/h2database/issues/4061#issuecomment-2155993198>. > > I hope it will help to manage your expectations about database file size. > On Monday, June 3, 2024 at 5:32:12 AM UTC-4 Rinse Lemstra wrote: > >> 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/0bc1fa36-4154-4b9a-9a47-887091467023n%40googlegroups.com.
