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?
Regards, Aaron
