Get creative and squeeze performance out of SQLite

Best Practices / Code Quality
09/05/2017 - 15:30 to 16:10
Stage Lamarr

Session abstract: 

Whether you love it or loathe it: SQLite is here to stay on Android, so let's make the most of it!  

Do you deal with a lot of data in your app, and need to insert it as fast as possible? We'll look at best practices (including how to apply them to the new Architecture Component: Room).

Is your database so large that queries take a long time to execute? We will discuss how to design indexes on your tables, and even go into how you could shard your tables when indexes don't provide enough of a boost.  

When it comes time to display your data, does your app run out of memory with all the data it needs to load into the RecyclerView adapter? Let's look into making an adapter that uses a Cursor.

And as a bonus: we'll talk about how you can cut out the middleman and have your server deliver an SQLiteDatabase file as a response format.

Session Video: 

Session Slide: