4,305 karma · joined May 5, 2009
https://blogs.nasa.gov/europaclipper/wp-content/uploads/site...
I bet it's roughly none.
He works on Asahi Linux, a Linux port to arm64 Apple hardware.
Computing the expressions should dominate execution time, right?
Then, to compare against the best possible case, we can write a custom C program that uses sqlite internals to perform the same task (full scan of the table, extract values from row) and does not use the bytecode VM and computes the complex expressions in regular C code (e.g. a function that accepts floats and returns a float or whatever).
Then comparing the two implementations will tell us how much faster sqlite can be if it had a "perfect" JIT.
https://twitter.com/gorilla0513/status/1784756577465200740
I was surprised to receive a reply from you, the author. Thank you :) Since I'm a novice with both compilers and databases, could you tell me what the advantages and disadvantages are of using a VM with SQLite?
https://twitter.com/DRichardHipp/status/1784783482788413491
It is difficult to summarize the advantages and disadvantages of byte-code versus AST for SQL in a tweet. I need to write a new page on this topic for the SQLite documentation. Please remind me if something does not appear in about a week.
Russian folk wisdom says "Жид крещёный - что вор прощеный. Веры нет" - "A converted Jew (slur) is like a forgiven thief - no faith/trust".
And in later times, "бить будут не по паспорту, а по морде" - you'll get beaten up on your face, not on (according to) your identification papers, a play on words meaning if you look Jewish, it doesn't matter that your papers say otherwise.