Re: [sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

Richard, you are my hero. :) On Mon, Jun 30, 2014 at 9:31 AM, Richard Hipp wrote: > A 64-bit Windows DLL is now available at > http://www.sqlite.org/download.html > > > On Mon, Jun 30, 2014 at 12:26 PM, Richard Hipp wrote: > > > > > > > > > On

Re: [sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

n postgres, for example, because they never updated the addressing code when they built a 64bit version -- a lesson I learned the hard way. ) On Monday, June 30, 2014, Simon Slavin wrote: > > On 30 Jun 2014, at 4:58pm, Nick Eubank > wrote: > > > Thanks Cory -- is this fixed in

Re: [sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

ne 30, 2014, Cory Nelson 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 > wrote: >

[sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

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 b

[sqlite] SQLite for single user data manipulation

Hello 'Liters! I'd like to move to SQLite from Postgres, but have two quick questions. I'm a social scientist looking to manipulate a large dataset (5 billion transactions, 700gb). I do not need multiple connections, and will only ever run one query at a time. I started in Postgres, but discover