Exploring search options for PHP
- by Joshua
I have innoDB table using numerous foreign keys, but we just want to look up some basic info out of it.
I've done some research but still lost.
1) How can I tell if my host has Sphinx installed already?  I don't see it as an option for table storage method (i.e. innodb, myisam).
2) Zend_Search_Lucene, responsive enough for AJAX functionality of millions of records?
3) Mirror my innoDB with a myisam?  Make every innodb transaction end with a write to the myisam, then use 1:1 lookups?  How would I do this automagically?  This should make MyISAM ACID-compliant and free(er) from corruption no?
4) PostgreSQL fulltext queries don't even look like SQL to me wtf, I don't have time to learn a new SQL syntax I need noob options
5) ????????????????????
This is high volume site on a decently-equipped VPS
Thanks very much for any ideas.