Derek, I'm more "onlooker" than "expert" here, but I think the answers are:
1) Yes, when a full table scan is performed, the entire table data is decrypted. (If you're using a LIMIT clause without an ORDER BY, then perhaps only part is decrypted -- the point being that the same pages are read and decrypted as would be simply *read* with a non-encrypted database.) For SELECTS where only index pages must be read, then only index pages must be decrypted. 2) For most modern computers, the time to read a sector from disk is much longer than the time to decrypt it, so that even though more CPU time is required, it may not significantly slow data delivery in many cases. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
