--- Joe Wilson <[EMAIL PROTECTED]> 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.
It seems that I did test against sqlite 2.x once before: http://www.mail-archive.com/sqlite-users@sqlite.org/msg16450.html There is more to consider other than just code size when trying to minimize memory usage. SQLite3 used 1/4 of the memory (temp store) as SQLite2 in a large bulk insert transaction. You have to test to see what works best for your application. ____________________________________________________________________________________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------