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

On Mon, Jun 30, 2014 at 12:14 PM, Nick Eubank wrote: > Sorry, I wasn't clear: I have 64 bit R and Windows, but since there are no > 64 bit binaries for SQLite I started with 32 bit SQLite. > > So now I'm wondering if I could fix this memory problem by installing the >

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

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 Mon, Jun 30, 2014 at 12:14 PM, Nick Eubank > wrote: > >> Sorry, I wasn't clear: I have 64 bit R and Windows, but

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 Mon, Jun 30,

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

Simon Slavin wrote on Monday, June 30, 2014 12:21 PM > > SQLite isn't a thing, it's an API. There's no SQLite server. There's > no particular installation of SQLite on a computer that Windows expects > to be in a particular place. You can have many copies of many > different versions of SQLite

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

On 30 Jun 2014, at 5:14pm, Nick Eubank wrote: > So now I'm wondering if I could fix this memory problem by installing the > 64-bit version of SQLite. SQLite isn't a thing, it's an API. There's no SQLite server. There's no particular installation of SQLite on a computer

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

Sorry, I wasn't clear: I have 64 bit R and Windows, but since there are no 64 bit binaries for SQLite I started with 32 bit SQLite. So now I'm wondering if I could fix this memory problem by installing the 64-bit version of SQLite. (I know that this wouldn't fix the problem in postgres, for

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

On 30 Jun 2014, at 4:58pm, Nick Eubank wrote: > 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. You are misunderstanding the problem. There is no bug to be

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

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

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

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: > Hi All, > > I'm a social scientist wrestling with

[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