I'm using h2 1.3.170 as a cache in an application that runs on Windows and Linux. Some users have disk quotas and run into various issues when the database file gets too large. Ideally I'd like to be able to query the database to determine how much data it contains, and delete old records as necessary to get the database size below some threshold.
I see that "Functions to calculate the memory and disk space usage of a table, a row, or a value." is on the Roadmap and thus is not supported yet. I know I can query for info.PAGE_SIZE and info.PAGE_COUNT to get how much space the database is using on disk, but that will not change as I delete data, so I can't tell how much I've cleaned up. I could guess at how much data to delete, "shutdown compact", re-open the database, and check the size, but that could cause a noticeable delay for the user. I'd like to avoid doing my own tracking of how much data I put into the database because it will slow down my operations and complicate my codebase. What's the best way to deal with this 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
