SQLite Forum

out of memory
Login

out of memory

(1) By anonymous on 2020-10-09 14:31:15 [link] [source]

Hello,

I'm getting out-of-memory errors in complex statements heavily using a mixture of aggregates and UNIONs. As far as I can see, SQLite seems to use only a few 100 MB (I've never seem a usage of more than 500 MB so far).

Is there a soft limit which I could raise? I'm using the 32-bit library (or CLI), so I'm aware there is a hard limit a little below 2 GB.

(2) By Stephan Beal (stephan) on 2020-10-09 14:53:01 in reply to 1 [link] [source]

I'm getting out-of-memory errors in complex statements ...

You might be overstepping one or more of the limits defined here:

https://www.sqlite.org/limits.html

(3) By anonymous on 2020-10-09 15:45:08 in reply to 2 [source]

Inspired by your comment, I compiled a 64-bit version of Sqlite CLI. It works fine with the same query consuming "only" about 350 MB of RAM.

To me it looks as if the 32bit-library of SQLite might have different limits than 64-bit library. But I can't identify such a difference on the cited page. There shouldn't be an actual OOM either as 350 MB could be managed on a 32bit platform as good as on 64bit.

PS: I'm on Windows.