On Wed, Apr 16, 2014 at 6:13 PM, RSmith <rsm...@rsweb.co.za> wrote: > > On 2014/04/16 03:39, Nick Eubank wrote: > >> I started in Postgres, but discovered that in Windows one cannot increase >> some of the per-query RAM memory caps above 2gb (I know -- I would love to >> switch operating systems, but it's beyond my control). So I'm thinking of >> moving to SQLite. >> > > Firstly, Windows isn't limiting the memory you can use, you can use all > 16gb installed memory, and in fact much more if needed (which will just > cause a lot of drive-swapping and slowness, but no less...), the 2gb limit > is in fact a 32bit limit and is self imposed by any 32 bit application
See also: https://sqlite.org/limits.html -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users