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. Quote 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. Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.