Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
I am seeing SQLite crashing during execution
of a SELECT statement when I make the page
cache very small (40 pages).
When I bump the cache up to 50 pages, the
problem goes away.
The problem only occurs on my RISC platform,
not on my x86-based platform. Also, I am
using SQLite 2 (not 3).
I've never used the sqlite2 library, so I can't comment on that.
But sqlite3 does a lot of checking in low memory situations
and has very robust error handling and recovery.
For example, SQLite3 is the only complex library I've seen that
can survive malloc returning NULL for no memory.
Actually, sqlite2 seems to manage quite nicely in
low memory situations, at least on my x86-based
platform: I was able to reduce MAX_PAGES to 1,
and TEMP_PAGES to 0, and sqlite2 still seemed to
run just fine.
It's only on my SPARC-based platform that I have
any problem, and that could be due to factors
beyond sqlite2's control. For example, there
could be a problem with the way we've redefined
malloc() and free() on that platform.
Without a decent debugger on that platform, it's
difficult to track down the problem. However,
I'm not going to worry about it right now; instead,
I'm going to upgrade to sqlite3. If the problem
still exists after I upgrade, then I'll worry it.
- Richard Klein
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
