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 Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/141745-mysql-performance-question/#findComment-747497 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.