SQL Mobile database size?

[Chris Botha]

The device calls a web service and on the server I am creating an SQL Mobile
database programmatically and the device gets the file bytes back and writes
it to disk.
Using VS2005 to create an SQL Mobile database creates a small database with
a half decent size, 36kb.
Creating a database programmatically on the server using the engine,
SqlServerCe.SqlCeEngine.CreateDatabase, creates an SDF database size 136kb,
thus a 100kb larger.
Both the Shrink and the Compact calls of the SqlCeEngine have no effect, it
stays 136kb.
Any idea how VS2005 manages to create the small size?

Thanks.

 

[Guest]

Probably just a difference in how they generate the root leaves. If you add
a dozen records to the tables do you see them equalize?

-Chris

 

[Chris Botha]

Chris, thanks, I should have done some more checking.
Adding tables increases the size noticeably - adding an empty table
increases the size by 8kb.