--- 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. ____________________________________________________________________________________ Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV. http://tv.yahoo.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------