Thanks Cory -- is this fixed in 64 bit versions of SQLite? I know postgres never changed memory address variable storage in the 64 bit so the problem persists.
Also: any advice on getting a 64bit installation for someone who doesn't really know how to compile C? Thanks! Nick On Monday, June 30, 2014, Cory Nelson <phro...@gmail.com> wrote: > Without special handling, any 32-bit Windows process is limited to a 2GB > user address space. Due to fragmentation during allocation, you'll never > reach a full 2GB. > > > On Mon, Jun 30, 2014 at 10:31 AM, Nick Eubank <nickeub...@gmail.com > <javascript:;>> wrote: > > > Hi All, > > > > I'm a social scientist wrestling with SQLite in Windows 8 (through R > using > > the RSQLite library) for some data manipulation and querying. > > > > No matter what I do to cache_size (or R's memory settings), SQLite never > > seems to be using more than about ~1900 mb of RAM. Is that a result of > the > > 32 bit build (on another project I discovered 32bit windows is limited to > > 1900 mb per thread due to how memory addresses are stored)? > > > > If so, any advice on installing 64bit version on Windows 8 for someone > with > > zero experience compiling C? > > > > Thank you so much! > > > > Nick > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org <javascript:;> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Cory Nelson > http://int64.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org <javascript:;> > 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