http://www.codeassembly.com/feed/comments/5 CodeAssembly - Simplicity is prerequisite for reliability - Comments en-us contact@codeassembly.com contact@codeassembly.com RSS Feed Generator Nice idea ... but in my case, I have a celebrity photo website with 100,000 photos, the search query would normally search the photos table for the caption, keywords table for keywords, celebrity names table and contributors table, to return the photos I need. If I was to put the caption, keywords, celebrity names in a search table for each photo, wouldn't that defy normalization? Or in the case of "full-text" does this not matter? I would be interested to hear your verdict on my situation. http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#384 2011-09-09 19:08:26 http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#384 Nice idea, but when handling volatile data, this can be cumbersome to mantain the search table. http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#274 2009-11-23 18:03:56 http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#274 Thanks for the information that you are giving. I want to see more. S. Charts http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#172 2008-10-31 02:30:32 http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#172 good tutorial and I have innodb to billion rows with mysql . thank you http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#166 2008-10-11 17:24:23 http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/#166