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]

Reply via email to