数据访问
SQL Server vs. SQL CE
16 cols
10 cols
Index
2GB
1GB
Max Blob
1 mil TB+
2GB
Max DB
64KB Extent
1KB Page
Page Increase
8K
4K
Page Size
SQL Server
SQL CE

| For those of you with SQL Server knowledge, you can see here a comparison of how SQL CE stores data versus SQL Server. It uses data pages that are half the size, and when necessary, increases its size in 1 kilobyte increments. The maximum database and blob sizes are 2 and 1 gigabytes, respectively, which is far more than most Pocket PC devices can currently support today. This ensures that your applications can scale to devices with larger capacities in the future. Finally, you can still create indexes, but they are limited to 10 columns.
| Let’s take a look at some more features.