天天看點

移動平台資料庫的一些限制(EDB、CEDB、SQL CE)

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