RE: [sqlite] Questions about sqlite's join translation

2004-10-11 Thread Keith Herold
This response would be good to put in swiki. --Keith ** - I'm not a professional; I just get paid to do this. - Things I've learned about multithreaded programming: 123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt rhheiianndgge dwi

[sqlite] Is it possible to 'fix' a malformed database

2004-10-11 Thread Paul Smith
If I do pragma integrity_check on a database I get: *** in database main *** On page 8 cell 0: invalid page number 1581 On page 8 at right child: invalid page number 1582 On page 7 cell 0: invalid page number 593 On page 7 cell 1: invalid page number 594 On page 7 cell 2: invalid page number 1171

Re: [sqlite] WinCE sqlite version 3.0.7 source code with fixes available?

2004-10-11 Thread Steve Frierdich
Nuno, You right. I just caught that last night, Sunday night, when I was working on it. Sorry for missing that. Does version 3.0.7 have datalocks? I know version 2.8.15 came equipped with datalocks. The config.h file for 3.0.7 version does not contain structures, define statements, inline

Re: [sqlite] WinCE sqlite version 3.0.7 source code with fixes available?

2004-10-11 Thread Nuno Lucas
Steve Frierdich, dando pulos de alegria, escreveu : Nuno, You right. I just caught that last night, Sunday night, when I was working on it. Sorry for missing that. Does version 3.0.7 have datalocks? I know version 2.8.15 came equipped with datalocks. The config.h file for 3.0.7 version does

[sqlite] concurrency in sqlite 3.0

2004-10-11 Thread Guillaume Fougnies
Hello, SQLite 3.0 concurrency was greatly improved via multi lock states. Despite this, some stuff seems, to me, quite inappropriate. Busy handler is the "sure" way to avoid deadlocks; But on heavily multi threaded systems, you are forced to determine an acceptable latency time to avoid many

Re: [sqlite] Is it possible to 'fix' a malformed database

2004-10-11 Thread D. Richard Hipp
Paul Smith wrote: If I do pragma integrity_check on a database I get: *** in database main *** On page 8 cell 0: invalid page number 1581 SQL error: database disk image is malformed --- Is there any way to "fix" this (even if some data is lost), or does it just need throwing away and restoring

Re: [sqlite] SQLite & stack size

2004-10-11 Thread Christian Smith
On Fri, 3 Sep 2004, D. Richard Hipp wrote: >Christian Smith wrote: >> >> How often does the balancer run? >> > >No so much, it turns out. Long ago, it used to run a lot >more often and was a high runner. But I've since optimized >it out of a lot of situations. > >So allocating with malloc()

Re: [sqlite] SQLite & stack size

2004-10-11 Thread D. Richard Hipp
Christian Smith wrote: Just run the test suite on NetBSD/sparc64, and test pagesize-2.3000.7 died with a SIGBUS. Full stack trace at bottom of mail[0]. #0 0x00108d80 in balance_nonroot (pPage=0x39dc10) at ../sqlite/src/btree.c:3045 3045p->aData = &((u8*)p)[-pBt->pageSize];

Re: [sqlite] SQLite & stack size

2004-10-11 Thread Christian Smith
On Mon, 11 Oct 2004, D. Richard Hipp wrote: >Christian Smith wrote: >> >> Just run the test suite on NetBSD/sparc64, and test pagesize-2.3000.7 died >> with a SIGBUS. Full stack trace at bottom of mail[0]. >> >> #0 0x00108d80 in balance_nonroot (pPage=0x39dc10) >> at

[sqlite] Version 3.0.8

2004-10-11 Thread D. Richard Hipp
Version 3.0.8 is now available on the website. http://www.sqlite.org/. The primary change is a series of code size optimizations. There are also some obscure bug fixes and a few minor enhancments. If you are not having problems with version 3.0.7 there is little reason to upgrade. -- D. Richard

Re: [sqlite] Version 3.0.8

2004-10-11 Thread Darren Duncan
At 9:09 PM -0400 10/11/04, D. Richard Hipp wrote: Version 3.0.8 is now available on the website. http://www.sqlite.org/. The primary change is a series of code size optimizations. There are also some obscure bug fixes and a few minor enhancments. If you are not having problems with version 3.0.7