Semantic search engine. Sphinx | Open Source Search Server for MySQ Land PHP. MySQL full-text search optimization. A while ago we where developing a classified ads site for one of our most important clients. In this site, every ad belongs to a region (city, country) and a category (e.g. vehicles>buy/sell>cars). When the visitor accesses the homepage, the region is determined from their IP address so only the ads for that region are displayed (the visitor can change the region) and every search is performed only for the ads on that region as well. At first everything was working great, but when some regions started to have more than 500.000 ads, that’s when we started to get nervous. Every search on these regions took more than 30 seconds, which is obviously unacceptable. After a lot of research over the internet, we came across a miracle.
How does it work? How can you solve this issue? How do you combine both dictionaries? Now every search on the site is working great and we are even using it to obtain all the ads from a specific category without a keyword, because it also takes less than a second. Full-Text Search. Datafacet. Open Source Enterprise Search.
Moteur de recherche PHP. NoSQL.