The client is osCommerce based store for safety, electrical, motor sports and industrial supplies. It has over 100,000 items in its catalog. The site was using default fulltext search due to which results were not accurate and performance was slow.
Our team implemented Sphinx Search for search. We designed custom indexes for store. We focused on indexing performance and implemented ranged queries and delta indexing.
Sphinx Search integration with this osCommerce store improve not only results accuracy but it also helped improve overall performance of the site. The search can be seen in action here