Posts

Showing posts from March, 2015

SPHINX with PHP and MySQL

Hope you guys are doing good! First let me tell you Why Sphinx is more faster than MySQL. Cuz Sphinx will search in Document format where as MySql search in table format. Now, how exactly it will work MySQL with Sphinx? 1. First you have to Download Sphinx-2.2.1-beta-win32.zip or Sphinx-2.2.1-beta-win32-pgsql.php. FYR, http://sphinxsearch.com/downloads/beta/ 2. Then you have to extract the files in C:/Sphinx 3. Copy your  sphinx.conf.in file and paste it under bin folder and rename it to sphinx.conf. 4.  Now open command prompt by pressing Windows -> cmd 5. Now you have to create service C:/sphinx/bin > searchd --install --config c:/sphinx/bin/sphinx.conf --servicename SphinxSearch 6. Then you have to create Log file under C:/Sphinx/log 7. Create PID file under log "searchd.pid" 8. Now its time to start the SphinxSearch server Go to Control panel -> Administrative tools -> Services -> SphinxSearch --Rightclick-> Properties -> S...