If this is true:
How can one full text search with PHP only? In other words, how can the search actually be processed in PHP while the data stays in MySQL?
Many thanks in advance!
Asked
Active
Viewed 2,334 times
2
-
Here's an example of a PHP full text search engine: http://framework.zend.com/manual/1.12/en/learning.lucene.intro.html – C. E. Jan 05 '13 at 05:35
-
@Calle does that search web pages or database data? Thanks! – Jan 05 '13 at 05:39
-
4000% faster may not make it a preferred option. in most php\mysql speed is not going to be an issue. have you benchmarked your search? is it to slow? – Jan 05 '13 at 05:44
1 Answers
1
There is most likely several ways to do this (although I can not say anything on the 4000%). What has came up most often is using something like sphinx or lucene.
http://sphinxsearch.com/files/talks/sphinx-nyphp_meetup-2011.pdf
Looking through SO there are a few questions that touched on the concept. php mysql fulltext search: lucene, sphinx, or? some good information - Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?
In most cases though performance searching in mySQL can be improved with indexes. Indexing Basic MySQL Queries - http://hackmysql.com/case1
