[rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

Cena, Stephen (ext. 300) SJC at qvii.com
Thu Mar 13 13:45:24 EDT 2014


 
Referring to: rt-users Digest, Vol 120, Issue 13, articles 8,9,10,11,13,14,15:

Thanks to those who responded. First, no; I did not know that full text indexing was supported after 5.0. I thought that was a 5.6 up & coming feature. I must not have a full grasp of how it works, because if MySQL has it built in why would I need to add on Sphinx? I do have much more familiarity with MySQL over Postgres which is one reason to stay with it. I've never used Postgres before.  I think Kevin's answer might be the easiest. I tried swapping out for MariaDB before, but got tripped up over table names being case sensitive. I'm trying to keep everything as simple as possible & I'd rather not dive into building my own MySQL.

I'll look into this some more and see what I can come up with. Thanks again to those who answered!

Stephen J. Cena
Systems Administrator - MIS/IT Dept
Quality Vision International
850 Hudson Ave
Rochester,NY 14620
Phone: 585-544-0450 x300
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Please report email problems to: postmaster at qvii.com

QVII MIS/IT Dept - We do what we must because we can.
"Thank you for helping us help you help us all."
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


More information about the rt-users mailing list