Re: [sqlite] understanding the query optimizer

Have you read this document? http://sqlite.org/optoverview.html I think it's good start for you. The main rule of optimizer is whether the query uses an index. On Wed, Nov 18, 2009 at 12:03 AM, P Kishor wrote: > Recent travails of the user trying to figure

[sqlite] what's the difference between exec and prepare-bind-step(C api)?

Deal all, I have used some SQLite application with sprintf and sqlite3_exec. It takes about 1 hour. And for test, they are changed to prepare-bind-step with same logic. After that, it takes about 2 hours. I tested it on ARM board and I don't know why. Please advise me. * Sorry. I can't support

Re: [sqlite] I think lemon bug

Oh, my source is not latest one. Thanks, problem is solved. On 10/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > > Your work-around is to say %%d instead of %d. Or (better) get the latest version of lemon where this bug is fixed. -- D. Richard Hipp <[EMAIL PRO

[sqlite] Re: I think lemon bug

Hmm.. sorry, maybe it's not a problem about directive. On my testing, '%' as modular operator doesn't cause problem. In printf, %u or %x works good. I think only '%d' is problem. On 10/13/06, Jong-young Park <[EMAIL PROTECTED]> wrote: Hi all. I want to

[sqlite] I think lemon bug

Hi all. I want to use "Lemon" parser generator for my own project because of multi-threading. But I find the strange bug. I made sample calculator program for testing. See the part of grammar file : expr(X) ::= expr(A) PLUS NUM(B) . { X = A+B; printf("plus-result : %d\n",X); } Af