@g-oku Based on the test scenario you describe, it is quite possible that you are running into an expanding database due to the repeated inserts, updates, and drops. SQLCipher does not automatically vacuum the database for you. As noted in the final point of the performance post, performing periodic vacuum operations will keep the database compact, particularly when you are performing large deletes, multiple updates etc. Can you try adding an execSQL(“VACUUM”); operation following the table drop, then re-running the test?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Android App becomes very slow after adding SQLCipher | 6 | 4790 | November 25, 2019 | |
| When performing transactions to insert data in batches, the efficiency of SQLcipher to insert data is much slower than that of sqlite | 6 | 1663 | October 19, 2020 | |
| Android Application slow down due to sql cipher | 1 | 1035 | November 30, 2020 | |
| SQLCipher Performance Optimization | 16 | 24600 | March 14, 2021 | |
| SQLCipher Database size keeps on growing even after deleting records from table | 4 | 2188 | September 7, 2021 |