1. Making an Embedded DBMS JIT-friendly
- Author
-
Bolz, Carl Friedrich, Kurilova, Darya, and Tratt, Laurence
- Subjects
Computer Science - Programming Languages ,Computer Science - Databases ,D.3.4 - Abstract
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., Comment: 24 pages, 18 figures
- Published
- 2015