db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: how to limit the derby db file size avoid eating up disk space?
Date Thu, 31 May 2012 13:31:26 GMT
> How to limit thesize of db file afterlarge amounts of insert and delete operation?

One common technique for handling this pattern of activity, is to use
a collection of tables, rather than a single table, and to drop entire
tables rather than deleting rows from an existing table.

For example, create a new table to hold each week's worth of data.

Keep the 10 most recent weeks of data online, by keeping the 10 most
recently created tables.

Each week, drop the oldest table, and create a new table for the new week.

Use UNION selects to process data from multiple tables.



View raw message