JanZ software and script
tep_get_category_tree optimization tep_get_category_tree optimization is the one that creates the contents of the drop-down menu (the one that starts with Top) in the top right corner of the categories.php page in the admin section.
Price: $GPL, Rating: 9, Downloads: 1423
Download
tep_get_path optimization tep_get_path optimization will eliminate all the queries that are getting the parent_id of categories on index.php where you have subcategories showing
Price: $GPL, Rating: 8, Downloads: 604
Download
tep show category optimization tep show category optimization will get the information in one query instead of using a separate count query for every category and subcategory shown in the categories box.
Price: $GPL, Rating: 8, Downloads: 486
Download
