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. thanks, bryan
