I am a total rookie at this, hoping someone could kindly give me some advice.
Basically the situation is I am implementing a database for use by a company who will be storing large number of photos taken by iPad (around 3000-5000 photos per Job) and will have to be stored on the database. And at any one time the company will be occupied by up to 10 Jobs, so that is 30000-50000 photos.
So if I were to centralise all the jobs in the same file would that be too much for the system and would affect the performance or experience of the users, Or should i create 10 different files and have them to log in to individual files for each job.
Many thanks for your advice