midnite Purr
New Member
Is there a best practice for storing only the latest (most recently inserted) x megabytes of records in a table of a SqlCE database?Specifically, I have a single table that basically breaks down to DateTime timestamp and NText message. I want to store as many records as possible up to a given maximum filesize. When new records need to be inserted, there needs to be room in the database for them, so the oldest records should be expunged. The records are of inconsistent sizes, so purging based off of a fixed number of worse-case-scenario records will not be ideal.