Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

[Warren Young]

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

[Raheel Gupta]

>> 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 Slavin  wrote:

>
> 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

[Raheel Gupta]

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