This project had around hundred MySql tables with tons of data. It had dozens of joins which produced extremely slow results. We took this job and converted all search queries (there are 6 search interfaces, each of which has multiple tabs) to use Elastic Search, which greatly increased the performance.
Technology used: MySQL Programming, Laravel, PHP, Elasticsearch.
To view project, click Here
Comments are closed