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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/0bc1fa36-4154-4b9a-9a47-887091467023n%40googlegroups.com.
