The client’s data model was complex with several base products having multiple variant products. The website was having a major performance issue on several pages including category pages and product pages.