On Mon, 2006-08-07 at 08:49 +0100, Lexington Luthor wrote: > Hi, > > I need fast text searching on a transactional table. Is it possible to > use transactions and text-search on a table together yet in any > production stable version of mysql?
Hi, One of approaches is to have "shadow" MyISAM table in addition to your Innodb table to perform full text search, which you can update in bulks or via triggers. You also can try sphinx: http://www.sphinxsearch.com/ which works with any storage engine and also much faster. -- Peter Zaitsev, MySQL Performance Expert MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]