out of memory
(1) By anonymous on 2020-10-09 14:31:15 [link]
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
> 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 [link]
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.