I tried with the 32-bit version of sqlite-for-Windows on a Windows 7 Home Premium desktop with 8GB - and the ":memory" database couldn't exceed 2GB.
The advice was to get a 64-bit version of sqlite-for-Windows. I asked - but didn't get a definitive answer - so excuse my asking again - where can we find a 64-bit Windows version of 3.7.11? Can one be added to the download page? I am not versed enough in compiling C code. Thanks ! On Sun, Apr 15, 2012 at 8:13 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Apr 2012, at 3:48pm, niXman <i.nix...@gmail.com> wrote: > > > Tell me please, what is the maximum size allowed for a ":memory:" > database? > > 64 GB is allowed? > > If the question was answered directly, the answer would be here: > > <http://www.sqlite.org/limits.html> > > bit it's not (though see answer 12). However, the internal architecture > of SQLite suggests that it's 64-bit clean, thus that the limit will be in > the OS, not SQLite, so what you really need to know is the limits of your > OS. Some expert on page-handling in SQLite might have a specific answer. > > The assumption for the standard 64 bit OSes these days is 64GB. Some > versions of Windows 7 can handle 192 GB (plenty of test installations since > it's actually useful to have that much memory in a Windows 7 server). Red > Hat Linux running on an AMD processor can handle 256 MB (proved by an > actual installation, but not seen personally by me). Apple's OS X 10.7 is > designed to support 16 TB of memory but I don't know of any test > installation. The most I've seen personally is 192 MB, which worked, but > was put together just for the lols and taken apart shortly afterwards once > the benchmarks had been run. > > 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