4 Aug
2010
4 Aug
'10
2:48 a.m.
On Mon, Aug 2, 2010 at 9:27 PM, Arjen Lentz <arjen@openquery.com> wrote:
Hi Monty
Real world feedback: almost all clients we have that use FULLTEXT need to not use it, because - they need the tables to be InnoDB for transactional/consistency reasons; since Aria is not transactional it's not an option. - FULLTEXT performance both for inserts and selects on larger datasets makes it unsuitable.
Agreed. I ripped virtually all of the MyISAM fulltext out at Craigslist and replaced it with Sphinx. Soon I hope to finish the job for the one corner where we have a little of it left. Bascially, I see it as choosing the best tool for the job: InnoDB for reliable data storage, Sphinx for full-text indexing. Jeremy