Long story short I’m having difficulties getting a decent time for an update operation.
I have two databases on an Android device.
- The main db that stores all the offline data on which the app functions
- A partial db which is an update downloaded from the server or uploaded directly inside the device.
The main db can and will get to around ~1GB in size.
While the partial db usually stores updates and should be decent in size. (max ~100MB)
Now, the idea is that the merge takes a decent amount of time given the data that contains blobs and other stuff but I will have to change the password after the update.
For 1GB main db size the Rekey can take ~15mins which locks the app for that period of time.
I also considered creating a new database with the new password and inserting everything into it to remove the rekey option but I’m still getting bad performance.
Can you please guide me with this matter? I would really appreciate it.