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> 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 > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
