Forum Moderators: coopster

Message Too Old, No Replies

optimizing mysql for picture uploads

how to optimize mysql for larger files

         

vkimura

11:35 am on Oct 28, 2004 (gmt 0)

10+ Year Member



Hi, I'm just wondering how I should structure mysql for my members to upload larger files such as pictures or other types of media files. In other words, if my members use pictures to upload should the pictures be stored in one folder or should a folder be created for each member. If I was to create a folder for each member (if that would be the most efficient manner) then how would I get linux or freebsd to create the folder dynamically? If I was to implement the former method (i.e. store all the members pictures in one folder) then would that not become really slow if there are a large number of members trying to access the folder?

coopster

8:44 pm on Oct 29, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



How about storing only the filename in a column in the database and then store the images in a folder? This is a common practice and certainly would help keep the bloat out of your mysql database and tables.