Unanswered: Best Method for storing lots of user data?
I am developing a an iPhone app that uses SQLite (client) on the mobile phone and MySQL on the Server (server). I will be syncing up data which will consist of data and images (using filesystem as opposed to BLOBS) between the phone and the server.
I am wondering which is the best method to store the users data on the server end. Should I create a table for every user? Store it as a flat file? or interweave all the users' data into one table. And finally should I create seperate folders for user?- to store their images?
Has anyone set up an e-mail server that supports multiple users?