On Fri, Apr 21, 2017 at 6:05 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 21 Apr 2017, at 4:18pm, Kim Gräsman <kim.gras...@gmail.com> wrote: > >> Unfortunately, we're getting occasional out-of-memory errors on >> statement execution. > > Is there a chance that your statements are making up temporary indexes ? > They can be arbitrarily large depending on how many rows you have in a table.
Could be. Would that show up in EXPLAIN somehow? The statement I've had trouble with so far is an UPDATE of a 5-million-row table. Thanks, - Kim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users