On Nov 3, 2:51 pm, Thomas Mueller <[email protected]> wrote: > So the initial database is about 10 times smaller than the database > with around 6 days of data. However, as far as I understand your use > case, the database should be the same size, right?
No, the database will grow over time. My application will insert 8000 rows to the table at each hour. The way to control the database size is a deletion policy in my application that will delete the data older than 14 days. However, the deletion policy never kicked in because the database will get slow with less than 14 days of data. > Could you run > SCRIPT TO 'fileName' at the first day and after 6 days, and post the > file sizes of the script? I ran the SCRIPT TO in H2 shell and get the following results. The size of the script with data at the first day : first.script 250M The size of the script with data after 6 days: 6days.script 1.2G Regards, Sheng -- 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.
