Currently i'm evaluating the possibility of moving from LIKE queries to FULLTEXT search on a site that gets around 30 multi-LIKE queries per second. The table is quiete simple, with auto_increment field and the FULLTEXT varchar. What I want is that being able doing multi substring queries like 'Adob* *hotosho*'.
Is that possible and is the performance is good enough for a server with 30-40 queries per second to process? I'm running latest MySQL 4.* on a freebsd dual athlon mp machine with 1gb of ram.
regards, Vahan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
