21 replies to this topic

[acidvertigo]

You can follow this thread about speed optimization:

http://forums.oscommerce.com/topic/119077-a-store-speed-optimization-in-progress/

[RMD27]

nutbolt, on 23 May 2011, 12:01, said:

This works in reducing a query in OSC 2.3.1 as well

in Catalog\includes\modules\boxes\bm_categories.php around line 61 comment out (using //) the following:

// if (tep_has_category_subcategories($counter)) {
	 //   $categories_string .= '->';
	 // }

in Catalog\includes\functions\general.php around line 421 comment out the following:

////
// Return true if the category has subcategories
// TABLES: categories
//  function tep_has_category_subcategories($category_id) {
//	$child_category_query = tep_db_query("select count(*) as count from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$category_id . "'");
//	$child_category = tep_db_fetch_array($child_category_query);
//
//	if ($child_category['count'] > 0) {
//	  return true;
//   } else {
//	 return false;
//   }
//  }

IMHO a waste of a query just to show a silly ..> after the subcategory and it slows your site down especially if you have loads of subcategories, the query has to array all of them first.

can this be done on the admin side of a 2.2 install as well?