Implementing messages cache in VK
This talk is about implementing messages cache in VK and fighting with SQLite.
Every day millions of people talk to each other through the VK social network.
How fast messages are uploaded and displayed is really important for us, and the local cache on SQLite helps us in that matter a lot.
From this talk, you’ll learn:
how we store every uploaded message for the longest possible amount of time;
how such a complex entity as message is represented in database;
how we quicken and optimize SQL queries.