Opencart too slow - cache or another solution?

JAY6390 wrote:Get vQmod and install this
http://www.opencart.com/index.php?route ... on_id=3703
Free mod and will speed up your categories at the expense of losing your category counts showing up. That is what causes the category speed issue

$results = $this->model_catalog_category->getCategories($category_id);
			
			foreach ($results as $result) {
				$data = array(
					'filter_category_id'  => $result['category_id'],
					'filter_sub_category' => true	
				);
							
				$product_total = $this->model_catalog_product->getTotalProducts($data);
				
				$this->data['categories'][] = array(
					'name'  => $result['name'] . ' (' . $product_total . ')',
					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url)
				);
			}
			
			$this->data['products'] = arr...

$results = $this->model_catalog_category->getCategories($category_id);

foreach ($results as $result) {
$data = array(
'filter_category_id' => $result['category_id'],
'filter_sub_category' => true
);
// here we will comment out the following line.
//$product_total = $this->model_catalog_product->getTotalProducts($data);

$this->data['categories'][] = array(
//'name' => $result['name'] . ' (' . $product_total . ')', // here is where you prevent the () from showing.
'name' => $result['name'], // here is where you prevent the () from showing.
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url)
);
}

$this->data['products'] = arr...

benlhe wrote:Hi pro,
I am fresh & with very little knowledge on coding, I encounter the same problem, I contacted my hosting co. they said server is running fine, it probably due to my own internet connection. But I was able to browse other websites smoothly only my site was lag on loading..... any solution or catch / something I can do to speed it up

This is my site with about 350 products --> http://www.qqbox.my
Thanks