Good Evening. I'm pretty new to mongo db and i'm planning to make an app who will work whit Nosql(MongoDB). The scope of the app is pretty simple: Register a profile Request item to a shopper Fulfill and sent payment notice.
If i would make this whit SQL i would create a User Table, A Request Item Table a sending Paymen Table.
I would, also in order to learn something, to make it whit NOsql, and i choose mongo. I could create 3 collection and put every different document and make a search every time i need. OR, and this is the question, COULD i create collection for EVERY user, and inside every user put every interaction of the very same user. So if i need to search for User10 order and paymen, i would look only inside User10 collection and search for every item he\she requested.
But on the other hand, how much can affect me if i need to search all order in a specific timeframe? It should be slower than SQL i suppose.
Is a acceptable way to do this, there are some backdraw i did not yet seen, or is discouraged in order to make another approach?
The backend would be write in Java, meanwile the app (for...reason) would be write in Xamarin.Form .