"Chris Nolan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Which version of MySQL?? The difference will be different (!!) depending > on the version in use. > > In general, full text search uses a tree-structure. Doubling the number > of entries in the tree is likely to result in a time difference of not > very much at all!
Currently using version 4.0.16 but will move to 4.1 and 5 when they're released.. How it works on those versions? According to what you described as a tree-structure.. then spliting a big full-text table into 2 smaller tables and use UNION just makes the situation worse... thanks -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]