Msg#: 3470083 posted 3:57 pm on Oct 5, 2007 (gmt 0)
I'm building a site which will allow users to upload images (CentOS/Apache/MySQL/PHP). The user will select an image to upload from their local machine then see a preview of the image and be prompted to select an area of the image for a thumbnail. Then both the full size and thumbnailed images will be saved to the server with a randomly generated 32 character filename (saved into mysql).
My testing site has all of the images being dumped into /image/uploads for full size images, and /image/uploads/thumbs for the thumbnails. After uploading quite a few test images I realized that I might have a scalability problem.
My initial thoughts on a better directory structure are this: /image/uploads/%year%/%month%/%day%/ /image/uploads/thumbs/%year%/%month%/%day%/
Is this a solid solution or is there a better idea? Should I just continue to let them pile up in a single directory. Any advice would be appreciated.