Search by Color with Elasticsearch

Search by Color with Elasticsearch

摘要

A year ago when I updated the TLE website I dropped the “search by color” functionality. Originally, all the colors were indexed into a database table and the frontend generated some complex queries to support specific and multi-color searching. On occasion, it caused some database bottlenecks during peak loads and with some particularly complex color combinations. The color search was also a completely separate interface from searching other product attributes and availability. It was neat, but it was not a great user experience.

It took some time to get back to the search by color functionality, but I've finally been able to get back to it and, with elasticsearch, significantly improve it.