SYSK 189: The Footprint of SQL Everywhere

The message is everywhere -- need an in-proc relational database for your “occasionally connected” mobile or desktop application, capable of query processing, transactions, persistence, and much more?  Then consider using SQL Everywhere Edition of Microsoft SQL Server technology, available as a free download.

 

Microsoft states that SQL Everywhere has a “compact footprint”, but how big exactly is it?

 

The hard disk space taken by “Microsoft SQL Server Everywhere” folder is 1,826,816 bytes.  That’s including the 20,480 bytes for README.htm, and 118,784 bytes for EULA_EN.rtf.  The runtime dlls take up 1,687,552 bytes on the hard disk.

 

Below are some private bytes measurements (averaged across 3 runs):

 

1. Windows app with one form and two buttons.  SqlServerCe.dll  is not referenced.

a).  Form1 loaded:  21,655,552

b). sqlServerCe.dll loaded via Assembly.LoadFile:  23,068,672 (1,413,120 bytes increase ≈ 6%)

2. Windows app with one form and two buttons.  SqlServerCe.dll  is referenced.

=> Form1 loaded:  23,248,896 (1,593,344 byte increase ≈ 7%, compared to 1-a)

3. Windows app with one form and 5 buttons.  SqlServerCe.dll  is not referenced.

=> Form1 loaded:  21,667,840 (12,288 byte increase  ≈ 0.056743%, compared to 1-a)

4. Added another blank form (Form2) to the project. 

=> Form1 loaded (form 2 is not loaded):  21,999,616 (344,064 byte increase  ≈ 1.6%, compared to 1-a)

5. Test case #2, plus create an instance of SqlCeRemoteDataAccess and SqlCeEngine classes, and execute CreateDatabase method (no dispose called)

=> 2,654,208 bytes ≈ 12%

6. Test case #2, plus create an instance of SqlCeRemoteDataAccess and SqlCeEngine classes

=> 2,535,424 bytes ≈ 11.7%

7. Test case #2, plus open and close local database connection using SqlCeConnection

=> 2,879,488 bytes ≈ 13%

 

Given, these tests are far from comprehensive… but it gives a rough idea on the hard disk and memory consumption by the SQL Everywhere classes.

 

For more information on  SQL Everywhere, visit the following sites:

• Datasheet:  http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b404e542/SQLServerEverywhereDatasheet_final.doc
• Books on line: http://www.microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en
• Download:  http://www.microsoft.com/sql/ctp_sqlserver2005everywhereedition.mspx

Comments

• Anonymous
  August 31, 2006
  Darn it, you got me all excited. I thought the final version was released ;-) I am so looking forward to the final release of this you have no idea. The Community tech preview is great, this whole things is great for simple mobile apps and desktop apps and well I could keep going, just about anyplace you do not have a server or just can't quite justify having a server or like when you have limited connectivity for not a lot of data.
  
  When you posted this I was like all excited thinking today way release day. Funny how I am as excited about this release of these 1.7 meg installer as I was about the release of VS 2005. Years I have wanted something like this.
• Anonymous
  August 31, 2006
  Irene Kennedy has some interesting things to say about Sql Server 2005 Everywhere Edition and how "compact"...