Is there any way to check how large an SDF file will grow before adding a row to it?

Question

Consider this scenario:

• I have an application that uses SQL CE and adds rows of messages in an SDF file.
• I roll over to a new SDF file when one reaches a certain size (say, 100MB). Meaning, I archive the old SDF file since it hits this maximum, and start logging to a new SDF file until it, too, hits this maximum. This process repeats itself forever.
• BUT: I want to roll over before my SDF file reaches that size.

Is there any way to check how large my SDF file will grow to before actually adding a row to it?

Let's say this is the schema for it: 1 table named MyMessages, which contains only 1 column named TheMessages which is of type VARCHAR(1000).

Answer 1

I do not know of any way to do this, in addition the file may shrink when the last connection to the file is closed due to the autoshrink feature. You will have to accept a margin and check in advance.