I have some questions for those that know the innards of SQLite.
What kind of interpreter does the query executor uses? How important is
the interpreter's speed, to SQLite's speed ?
Concerning above questions, i've found a great article about a portable
interpreter implementation that produces a close to JITed performance,
interpreter:
http://www.emulators.com/docs/nx25_nostradamus.htm
Another idea for producing a portable JIT (without an assembly backend)
is what QEMU does, by "chaining" precompiled functions. Arguably QEMU's
way is more heavy/complex than using an interpreter, but maybe it
wouldn't bloat SQLite that much, and SQLite would remain portable across
platforms.
I'm asking above questions, because i believe that due to SQLite running
on billions of devices it needs to be as efficient as possible. Due to
the number of deployments, it may "burn" GWatts of power across all
these devices (i haven't done the calculation).
Thanks,
lefteris.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
