I have a embedded system which uses C/C++ api with a compiled version of SQLite v3. I get a SQLITE_NOMEM error on pragma integrity_check(10);. I asked the underlying system programmer what the applications heap size is and he tells me that the value is 500k. And also there's a SQL vector size of 4096.
What options do I have to get rid of this? Except splitting the databases to multiple ones?
Increasing heap memory size to 1.5M fixed this problem.