Martin Trnovec wrote: > D?a 24.04.2016 o 8:39 Clemens Ladisch nap?sal(a): >> Android (and Chromium on Android) just use SQLITE_TEMP_STORE=3 for this >> reason >> >> Apparently, Martin's SQLite library was compiled differently. > > That's right we have our own build of sqlite included in c++ common > library for all platforms, that's why we are facing this issue. We > solved it by changing temp dir into application directory containg > other files as well
You should use the cache directory. > but now i'am considering using memory (SQLITE_TEMP_STORE=3). But > there is a big but as we are using long and heavy transactions with > long statments (INSERT OR REPLACE ... SELECT ... FROM ... )and we > don't want that device is running out of memory so is the lenght of > transaction somehow influencing size of temp file ? The size is influenced by the amount of changed data that might need to be restored later. Regards, Clemens