> On Jan 29, 2019, at 10:12, Jens Alfke <j...@mooseyard.com> wrote: > >> On Jan 28, 2019, at 3:35 PM, Richard Hipp <d...@sqlite.org> wrote: >> >> On the other >> hand, if you set SQLITE_TEMP_STORE=2 so that intermediate results are >> held in memory, then intermediate results may be written to swap space >> when the device gets under memory pressure. > > Mobile OSs don’t swap. (iOS for certain; I don’t have confirmation of this > for Android, but our local Android dev believes it’s so.)
While iOS 12 does not swap memory in the traditional sense, there are conditions under which it may write an idle application's memory to disk. Scott _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
