Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.
On 12/3/2013 17:29, James K. Lowden wrote: Determinism is a property of a function; there is no such thing as a function that is sometimes deterministic and sometimes not. Unless you're new to this computing thing, you must have noticed that software developers almost never mean the same thing as mathematicians when we use the word "function". There are tiny corners of the programming world (FP) where this is not the case, but then you get into questions of purity, and databases are about as far from side-effect-free as you can get. Anyway, all this arguing over how SQLite *should* behave seems misguided to me. What matters is how SQL is specified. SQLite should follow the spec in areas like this. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Encryption
>> The answer may depend on what storage system you were using 7200 RPM Sata Drives >> whether you have small or big databases, Big which may even reach TBs of data. >> and whether you have just one user at a time or many users at once. Multi user. I do use WAL mode. On Wed, Dec 4, 2013 at 6:18 PM, Simon Slavinwrote: > > On 4 Dec 2013, at 10:45am, Raheel Gupta wrote: > > > I wanted to know which is the best in performance ? > > There would probably not be a simple definite answer that applied to all > setups. The answer may depend on what storage system you were using, > whether you have small or big databases, and whether you have just one user > at a time or many users at once. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Encryption
Hi, I wanted to implement Encryption on my sqlite DB with least load on performance. I have come across Sqlcipher.net and SQLite Encryption Extension (By Dr. Hipp) I wanted to know which is the best in performance ? Has anyone tested both of these and can provide some feedback ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users