BUSINESS PROBLEM - slow page load means lower conversation rate
To build Filter Navigation, Pagination, Short ordering, Product List or anything(!) in milliseconds looks like an "impossible mission".
MY IDEA AND SOLUTION
You can use SOLR or ELASTICSEARCH as a data analyzer and search engine to get all data what you need to build (render) your page in milliseconds. Both based on Apache Lucene and gives you an enterprise solution.
On front end I have used AngularJS to show you how easy to drive a page by JSON with an MVC framework.
DATA DRIVEN BLOCK(S) FOR MARKETING
As a business owner or marketing professional you can drive any block like a BANNER by data. The banner is driven by Gender Filter Option in this case.
HOW YOU CAN TEST IT?
Click on any filter option or pagination below. "Page load" is blazing fast and very stable.
TRY TO FILTER 1.000.000 products! There is NO CACHED PAGE or cached respons!