Performance analysis on Android SQLite database
Nikola Obradovic, Aleksandar Keleč, Igor Dujlović · 2019
Database performance is a very important factor in the development of any application. Some applications need very fast feedback, others process a large amount of data and without the support of modern database management systems, this is almost impossible. In this paper main focus is to analyze SQLite Android relational database management system and test its performance in several scenarios: dealing with CRUD operations on unencrypted data, encrypted data, as well as concurrent access to the database. For this purpose, an application that demonstrates performance impacts on the SQLite database has been developed and published on the Google Play Store. Testing results show that operations over encrypted data take much longer than on unencrypted data. Furthermore, it is shown that a new SQLite locking and journaling mechanism provides concurrency with an efficiency of 40-44%.