On Fri, Oct 31, 2008 at 06:42:57PM -0700, Kelly Jones wrote: > Can RT support MySQL fulltext searching? > > I can easily create a FULLTEXT index on Attachments, but can I add > this to the web interface somehow?
I think that RT needs/requires InnoDB tables to function properly. FULLTEXT indexes in MySQL only work with MyISAM tables, per the documentation. There is a patch in the wiki to add FULLTEXT to RT with an Oracle backend and a very similar patch would work with a PostgreSQL backend. We are planning to use PostgreSQL with FULLTEXT here and will submit an item to the wiki once we have it working. Ken > > Searching for "Content matches 'whatever'" is unusuably slow, > especially when you have tons of large binary attachments (the > $DontSearchFileAttachments setting doesn't seem to help much). > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
