SQL Mobile database size?

  • Thread starter Thread starter Chris Botha
  • Start date Start date
C

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.
 
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, thanks, I should have done some more checking.
Adding tables increases the size noticeably - adding an empty table
increases the size by 8kb.
 
Back
Top