Re: [sqlite] SELECT crashes with small cache?

2007-10-09 Thread Richard Klein
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

Re: [sqlite] SELECT crashes with small cache?

2007-10-07 Thread Joe Wilson
--- 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. > > >

Re: [sqlite] SELECT crashes with small cache?

2007-10-06 Thread Joe Wilson
--- 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

[sqlite] SELECT crashes with small cache?

2007-10-05 Thread Richard Klein
Hello all, 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