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...