Apologies this reply went to the wrong mailbox - rectified here.
On 2014/07/01 20:19, Gert Van Assche wrote:
Thanks for your replay.
I'm not a developer, and I don't know how to compile the source code.
The reason why I think I will need a 64-bit exe is that the 32-bit one is
limited to 2GB RAM in memory.
As I'll have to read/wrtite a lot to a huge db, I think a 64-bit might help me.
gert
By "help me" I assume you mean setting a cache-size that is sufficiently big to
speed up database processes of very large size DBs?
The RAM usage is an OS limitation, not one of the program. SQLite (or any other program) can only ask for a memory allocation, which
may or may not fail. Allocating more than 2GB of memory by just one application (such as sqlite3.exe) is plausible, however I don't
know if sqlite3.exe or the sqlite code in general is able to manage more than 2GB of memory or more than 32bit addressing (even when
compiled in 64 bit guise). This is a separate issue to the OS's ability to address more than 2GB memory (It might be able to read
16GB of memory and still only supply <2GB chunks of it to 32bit apps).
Even then, I think there is a hard upper limit to the cache size that can be
specified, but cannot find it now - For information see:
http://www.sqlite.org/pragma.html#pragma_cache_size
http://www.sqlite.org/malloc.html
I seem to remember a similar question having surfaced some time ago but cannot find the reference now - so let me ask the great
forum devs again: WIll the 64-bit version of sqlite3.exe be able to use >2GB of memory for itself, is this different to the 32bit
version, and if so, does anyone have a pre-compiled 64bit sqlite3.exe version please?
Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
