*** 36,38 **** --- 36,58 ---- Due to a coding error, the NOT NULL constraint on a primary key is not enforced. It probably should be. For both INTEGER PRIMARY KEYs and for PRIMARY KEYs of other types. + + **Index Only Tables** + + A great deal of space is wasted in an SQLite database if every column + is also included in the index. Index-only tables could alleviate this + problem. + + **Bitmap Indexes** + + When dealing with low-cardinality columns it would advantageous in + terms of both space and speed to support Bitmap Indexes rather + than b-tree based data structures. + + **More Efficient Disk Format to Accomodate Random Access to BLOBs** + + SQLite currently has to read the entire BLOB into memory to manipulate + parts of it. It would be extremely conveniant to offer an API that + could quickly seek to any part of the BLOB without reading the leading + data first. It would also be faster and require less memory for the + host application.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|