all AI news
Quoting D. Richard Hipp
Simon Willison's Weblog simonwillison.net
Performance analysis indicates that SQLite spends very little time doing bytecode decoding and dispatch. Most CPU cycles are consumed in walking B-Trees, doing value comparisons, and decoding records - all of which happens in compiled C code. Bytecode dispatch is using less than 3% of the total CPU time, according to my measurements.
So at least in the case of SQLite, compiling all the way down to machine code might provide a performance boost 3% or less. That's not very …
analysis code cpu decoding least performance performance analysis records richard sqlite total trees value walking