I'm wondering what the best practice is for photo storage. I'm in the business of storing photos with a user. Each user can have up to 35 photos and we currently have around a 100k users. I currently reference the photo's from a database.
My proposed solution is a hash of the photo name like so.
broke out into directories like so
database Stored in the database as a comma separated array like so for sort ordering.
Is this the most efficient way to do this? and is it scalable? I'm not sure if the photo hash is to large and I'm also not sure if the directory size is correct.
I created a more detailed post over on stackoverflow, just not sure where this question belongs. https://stackoverflow.com/questions/19106596/how-to-store-photo-on-file-system-and-store-sort-order-in-database