Is there any way or best practices to delete documents locally while keeping them in the server?
Our users (Native Android and Phonegap (android/ios) app) will be creating about 300 documents per day plus about 300 edition so the local database will grow quickly. I’m thinking on a scenario where documents older than 3 months are deleted on the local database but they are still on server (I don’t want to lose that data). In case the user needs to look at old data, I will request them on demand. I’m assuming performances slow down when the amount of documents grow.
The first question is: Is this scenario viable? how?
I’m aware performance depends on hardware but is there any information about the recommended amount of local documents to have a great user experience and don’t build a slow app?