peuge Posted January 21, 2009 Share Posted January 21, 2009 I have a artist site, whereby each artist get their own customized page (www.domain.com/artist_name). The customized page has a gallery. The gallery works by getting all the files (pictures) in a specified folder and then uses the filenames against a database to get the other data (medium, category, price etc). Is the above method ok? Or should the pictures be in the database itself? Would it be quicker or is there not much of a difference? Thanks Link to comment https://forums.phpfreaks.com/topic/141745-mysql-performance-question/ Share on other sites More sharing options...
Mchl Posted January 21, 2009 Share Posted January 21, 2009 It is OK as it is now. Storing pictures (or binary files in general) within database itself is useful only in rare cases. For gallery like that, storing pictures as files is perfect. Link to comment https://forums.phpfreaks.com/topic/141745-mysql-performance-question/#findComment-742021 Share on other sites More sharing options...
fenway Posted January 27, 2009 Share Posted January 27, 2009 Until replication becomes a factor. Link to comment https://forums.phpfreaks.com/topic/141745-mysql-performance-question/#findComment-747497 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.