Maxing out SQLite performance with Rashanjyot Arora
This talk aims at helping developers improve database and query performance, covering the nuances of SQLite (and Room, especially in a reactive android world).
Why is this important?
Apps are increasingly storing more and more data and some of them are even becoming completely offline first.
Screen refresh rates are continually growing, and the faster we can cook up the data to be rendered, the better it is.
What this talk will cover?
What are Indexes and their types (single-column, multi-column, partial, covering, expression-based etc).
Evaluating impact of indexes via examples.
Support for indexes in Room and how to get around what Room doesn’t support yet.
A common issue with queries in the reactive world and how to get around it.
Pitfalls of using database views.
(Optional) Understanding advanced SQLite features such as pragma commands - vacuum, optimize etc
