On Sat, Nov 01, 2008 at 05:13:07AM +0300, Ruslan Zakirov wrote: > On Sat, Nov 1, 2008 at 4:42 AM, Kelly Jones <[EMAIL PROTECTED]> wrote: > > Can RT support MySQL fulltext searching? > No. InnoDB has no fulltext indexes. > > > > > I can easily create a FULLTEXT index on Attachments, but can I add > > this to the web interface somehow? > > > > 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). > > As someone posted, MySQL full-text indexing does not work with InnoDB tables. I would recommend changing your backend to Oracle and use the existing full-text patch in the wiki or to PostgreSQL which should work with minimal changes to the patch. We will be working on the PostgreSQL full-text support soon. Good luck.
Ken _______________________________________________ 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
