SQLite Forum

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.