N/APosted on - 10/17/2013
I need to do PHP MySQL full text search in a large database that is constantly changing. Please suggest me the best MySQL built in method to search this kind of databases. Waiting to hear from experts.
Thanks, Emma Marie
PHP MySQL full text search
I would suggest you to do your full-text search by downloading Sphinx. It is a very fast means and plugs directly to MySQL and PostgreSQL, MSSQL, ODBC and XML pipe. It handles some major sites like ljseek.com (120+ GB database) and rss-spider.com. It is available for Linux, Windows and Mac OS. It provides not only full text search but many other categories. Download sphinx from internet, Install and enjoy your search.
Another option is ZEND framework which belongs to Lucene class. It is 100% PHP server and provides with Lucene Binary Compatible Index.