I'm busy building an application that will have 10 million records, each with a chunk of text - about 500 words each, on average. Does anyone have any benchmarks they can share with mysql's fulltext search performance on indexes of this size?
What I'd like to know is what size server I need to run this app on. How much RAM, how much CPU and what sort of disk channel performance I need to provide? I'd like to get sub 1 second responses, and all fulltext queries will be boolean using the 'IN BOOLEAN MODE' modifier. Thanks, Mark. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
