Hi everyone, I have a question regarding the performance of UNION queries:
I need to do a full-text search against a large number of rows. Is it faster to have one table with 10,000,000 text rows and perform one full-text search. Or, am I better off having 10 smaller more managable tables and performing UNION'ed full-text searches against them. A merge table seems like it would be the ideal solution, but the limitation on full-text indexing prohibits it. Thanks! -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]