2026-08-14T15:14:43Z https://drops.dagstuhl.de/oai

oai:drops-oai.dagstuhl.de:6098 2024-03-06T10:37:59Z ddc:004 open_access

Making an Embedded DBMS JIT-friendly Bolz, Carl Friedrich Kurilova, Darya Tratt, Laurence DBMSs JIT performance tracing While database management systems (DBMSs) are highly optimized, interactions across the boundary between the programming language (PL) and the DBMS are costly, even for in-process embedded DBMSs. In this paper, we show that programs that interact with the popular embedded DBMS SQLite can be significantly optimized -- by a factor of 3.4 in our benchmarks -- by inlining across the PL / DBMS boundary. We achieved this speed-up by replacing parts of SQLite's C interpreter with RPython code and composing the resulting meta-tracing virtual machine (VM) -- called SQPyte -- with the PyPy VM. SQPyte does not compromise stand-alone SQL performance and is 2.2% faster than SQLite on the widely used TPC-H benchmark suite. Schloss Dagstuhl – Leibniz-Zentrum für Informatik Carl Friedrich Bolz and Darya Kurilova and Laurence Tratt 2016 Is Part Of LIPIcs, Volume 56, 30th European Conference on Object-Oriented Programming (ECOOP 2016) InProceedings Text doc-type:ResearchArticle publishedVersion application/pdf doi:10.4230/LIPIcs.ECOOP.2016.4 urn:nbn:de:0030-drops-60986 https://drops.dagstuhl.de/entities/document/10.4230/LIPIcs.ECOOP.2016.4 eng https://creativecommons.org/licenses/by/3.0/legalcode