katlis Posted February 3, 2009 Share Posted February 3, 2009 If you had a photo gallery, for example, and needed a way to search for photos via keywords, would it be faster to search a table with a csv structure like this? imgID1 | keyword1,keyword2,keyword3 imgID2 | keyword3,keyword4,keyword5 or a keyword table like this? keyword1 | imgID1 keyword1 | imgID2 keyword2 | imgID1 Any other ideas or input is greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/143693-whats-a-faster-database-schema-for-photo-keywords/ Share on other sites More sharing options...
trq Posted February 3, 2009 Share Posted February 3, 2009 The second method would be best. Link to comment https://forums.phpfreaks.com/topic/143693-whats-a-faster-database-schema-for-photo-keywords/#findComment-753949 Share on other sites More sharing options...
katlis Posted February 3, 2009 Author Share Posted February 3, 2009 The second method would be best. The best out of the two methods, or the best way to do it period? Link to comment https://forums.phpfreaks.com/topic/143693-whats-a-faster-database-schema-for-photo-keywords/#findComment-753977 Share on other sites More sharing options...
fenway Posted February 6, 2009 Share Posted February 6, 2009 The best, period. Link to comment https://forums.phpfreaks.com/topic/143693-whats-a-faster-database-schema-for-photo-keywords/#findComment-755794 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.