out of memory
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.
I'm getting out-of-memory errors in complex statements ...
You might be overstepping one or more of the limits defined here:
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.