opencart/opencart — pull request #46 by chrisatomix (2012-08-10 09:56:50+00:00)
Title: Improved SQL Performance of Category Module

The Category Module can now display unlimited nested categories along with their respective product counts/totals with a single SQL query (rather than looping through each category and running multiple SQL queries). Needs some work to fully integrate it, but shouldn't cause any breakages. Potential to add depth parameters in future (ie show top 2/3/4 levels).