Hi there, I have a large and growing table in H2 with approx. 5M rows.
To increase performance, I periodically archive older data and move them off to a separate table. In the recent archive, around 600k rows were removed from the table. After the purge I noticed that H2 CPU usage increases from 20-30% average to +60% and queries to the database in general become much slower than previously. The only way around the problem it seems is to shutdown the database with "SHUTDOWN DEFRAG" and performance returns to normal. Does deleting a large amount of data from a table cause page fragmentation in H2? Some details of the environment as follows - H2 Version - 1.3.154 Cache Size - 260M JVM Heap - 892M Multithreaded - No Thanks. -- 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.
