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


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.

To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to