Hi, I removed a significant amount of rows in the db tables, as well as some index and unused tables. However the .h2.db file stays the same (46.0 GB, it's pretty big hence the need to reduce the size of it). Is this normal?
I see some temp.db file appear during the deleting row command and each of these temp.db files are a few hundred MB large. All the deleting row command runs sucessfully and I double-check the DB with SELECT * FROM table_name to ensure rows have been deleted. I suspect they are still stored somewhere in the db.file? How to clean it up? Best, Sen -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
