--- Bill KING <[EMAIL PROTECTED]> wrote: > Daniel Önnerby wrote: > > Hi everyone! > > > > I'm just a bit curios if it would be possible to make like a C > > precompiler or a macro of some kind that compiles/interpret the > > SQL-statements to bytecode just like the sqlite_prepare does but does > > this when compiling/precompiling your application instead of at > > runtime. Since most application written in C/C++ use static > > SQL-statements (unless you are building your SQL-strings on the fly) > > and then bind the values, I guess there would be several benefits for > > your compiled application: > > * Faster: Since the SQL-statement is already interpreted. > > * Smaller (not that sqlite needs to be smaller): The executable does > > not need to contain the part of sqlite that interprets the > > SQL-statements since this was made at compile time. > > > > Just a thought :) > > > > Best regards > > Daniel Önnerby > > > I second this. I use a lot of different database handles (due to a lot > of multi-threading), so there's no way I've seen yet to compile an sql > query that i can distribute to the different handles, so every statement > gets prepared just before run. Huge performance hit. If we could even > just pre-compile once per run, and attach to a database handle afterwards...
I recall reading on this mailing list that DRH sells a version of SQLite that can be compiled without a SQL parser that works with precompiled statements. > > -- > Bill King, Software Engineer > Trolltech, Brisbane Technology Park > 26 Brandl St, Eight Mile Plains, > QLD, Australia, 4113 > Tel + 61 7 3219 9906 (x137) > Fax + 61 7 3219 9938 > mobile: 0423 532 733 > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com