Posts Tagged ‘tools’
Got Data? Need Search? Use Sphinx
So you've built your web application, and people are putting data in it, but how do they get that data back out? Often, they find data by searching. MySQL provides a searchable full-text index, but it has several limitations: FULLTEXT indexes are only available on MyISAM tables. Adding FULLTEXT indexes can slow down INSERTs and UPDATEs. FULLTEXT indexes can span multiple columns, but not multiple tables of data. Searching can increase the load on your database server. Fortunately, a search system, like Sphinx, allows you to overcome these limitations and provide powerful, flexible, and fast ... Read More »
