I am still not clear if page level encryption permits equality searches and range searches? Intuitively it would seem that these searches would require every page to be decrypted to access the column data for each record...
unless a proxy Index is used as suggested here http://blogs.msdn.com/lcris/archive/2005/12/22/506931.aspx in the form of a MAC. Does SQLite maintain such a proxy for Keys when Page encryption is enabled? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
