On 2014-02-04 00:43, Steven Hall wrote:
We have a power cycle test that powers the device, starts H2 and the application and then cuts power. We run this test for hours cycling power every minute. We have a H2 database with three tables and a small number of rows, maybe a thousand rows total. This db is 99% reads. When we start the power cycle test this db is around 1MB. After a few hours the .db file grows many times larger. The largest I've seen is 200 MB. This is a problem as this is an embedded device with a small amount of storage.
Try tweaking this setting: http://h2database.com/html/grammar.html#set_max_memory_rows It's possible you are creating a lot of temporary tables for large result sets. -- 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.
