Feature | EDB | CEDB | SQL Server CE 2.0 |
---|---|---|---|
Maximum volume size | 64 MB | 16 MB | 2.14 GB |
Maximum record size | 8 KB (excluding stream data) | 128 KB | 4 KB |
Maximum number of properties per database | 1,024 | No limit | 255 |
Maximum property name length | 128 characters | Not supported | 128 characters |
Maximum volume name length | (MAX_PATH - 13) characters | MAX_PATH flag | 128 characters |
Maximum number of sort orders | 16 | 4 | 249 |
Maximum number of properties in a sort order or index | 16 | 3 | 10 |
Maximum key length in a sort order or index | 512 bytes | 512 bytes | 510 bytes |
Default lock escalation value | 100 | Not supported | Not supported |
Maximum number of concurrent transactions | 255 | Not supported | Not supported |
Maximum password length | 40 characters | Not supported | 40 characters |
Maximum number of open database handles | 256 | Not supported | Not supported |