Best practice for multiple users data
I'm developing a web application that would need multiple users to use their data individually. Each user would only be able to see their own captured data in forms, views, etc. What would be the best practice to achieve this and working without problems? I can see three options:
- Each user is only allowed to enter and see their own data, but all of them working in only one WordPress/Formidable installation. I'm concerned that in some time the data would grow in an unconvenient way, for example that every user would reach hundreds or thousands of records and there would be, let's say, at least fifty users. I don't know how to anticipate if there would be problems with data handling, from storage to a possible mixing of records. The advantage of this method is obviously the easy way to update the application for all users.
- Each user is given their own WordPress/Formidable installation and no one cares about other users working in parallel, but I don't know how to manage anytime the application must be updated (imagine working on the code of every installation).
What would you recommend?