I am loving what I am seeing and using when it comes to Realm, but I having a bit of hard time wrapping my head around some structure and hope the community can help provide some insight.
Lets say you are building a cash register app. To place everything in a single realm and sync everywhere sounds great, but can become very bloated (thing about a years worth of register transactions multiplied by the number of customers using your application) and every time someone logs into a new device, the entire database would have to be downloaded.
I then thought about 2 realms, 1 for all the settings which is synced everywhere and 1 with all the transactions (using query based synchronization) where I could sync only the past month of transactions and require online access to go back further. After reading the docs though (correct me if I am wrong) I believe subscriptions only live as long as the app is open. If the app closes, I would have to re-download the past months worth of data. Additionally, I was being lead to believe (again, correct me if I am wrong) that query based synchronization is very resource intensive, so if I ended up having hundreds or thousands of clients using this, am I causing myself more issues then necessary?
Is there something missing or a better way to handle this scenario?