On Jul 19, 2005, at 7:50 PM, Aaron Burghardt wrote:
On Jul 19, 2005, at 4:21 PM, Doug Currie wrote:
[...] If I have exceeded the amount of free space,
though, attempting to commit the transaction will fail.
That is also as expected. SQLite will cache modified pages in RAM,
and
attempt to write them to disk at commit time.
OK, that's for the explanation.
So, to avoid running out of disk space, I should stop inserting
records when the amount of free disk space falls below (PRAGMA
cache_size;) * 1.5 KB? Is there a better guideline?
Sorry, I meant "thanks for the explanation", of course.
Also, I didn't look closely enough at the caching pragmas. The best
threshold to avoid running out of disk space appears to be:
(PRAGMA cache_size;) * (PRAGMA page_size;)
Does anyone recommend anything different?
Thanks for the help,
Aaron
