This is shockingly simple… Almost so simple that I’m waiting for the problems, but after five days there has been none so far! When you develop a web application, at some point SQL query optimization just don’t cut it anymore. At Gatorpeeps, you will see we show each user’s latest blog post underneath each of [...]
Now that you have been introduced to Sphinx Search, its time to set it up or install it. It is extremely simple. Just have a look at the guide for Debian, to give you an idea: sudo apt-get update sudo apt-get dist-upgrade sudo apt-get install build-essential sudo apt-get install libmysqlclient15-dev tar xvzf sphinx-0.9.8-rc2.tar.gz cd sphinx-0.9.8-rc2/ [...]
Full text search is usually not a nicety, but often a necessity. To search a database text field by simply doing a normal SQL query could often result in a slow query, which is NOT GOOD. Now, you might not always have a need for full text search, specially if you have a smallish data [...]