--- 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]
-----------------------------------------------------------------------------

Reply via email to