hi all I want to know if adding 14 fulltext indexes on 14 columns would be faster , or adding all the words in the 14 fields to one big text column and then fulltext index it is better ? i dont know how mysql keeps the fulltext indexes, but if each index is kept on a file then 1 big column is better ,as only one file is opened . On the other side , if MySQL considers covered queries ,then 14 full text indexes are gona be better . Thats my opinion , but i wanna hear yours .
_____________________________________________________________ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _____________________________________________________________ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php