What is the largest shop so far, any scaling issues?

chris17453 wrote:kill children counts. That gave me a ton of speed

$product_total = $this->model_catalog_product->getTotalProducts($data);

$product_total = $this->model_catalog_product->getTotalProducts($data);

$product_total = $this->model_catalog_product->getTotalProducts($data);

'name'  => $child['name'] . ' (' . $product_total . ')',

'name'  => $child['name'] . ' ',

AndyGaskell wrote:Perhaps we could have a config setting called "show product counts", so we could switch off product counts easily .

rph wrote:Q added it to the SVN a while back.

rph wrote:A little more complete/consistent code:

/catalog/controller/common/header.php
/catalog/controller/product/search.php

Replace

Code: Select all

$this->data['categories'] = $this->getCategories(0);

with

Code: Select all

		if ($this->cache->get('search.categories.' . $this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id'))) {
			$this->data['categories'] = $this->cache->get('search.categories.' . $this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id'));
		} else {
			$this->data['categories'] = $this->getCategories(0);
			
			$this->cache->set('search.categories.' . $this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id'), $this->data['categories']);
		}

/admin/model/catalog/category.php
public function addCategory
public function editCategory
public function deleteCategory

Replace:

Code: Select all

$this->cache->delete('category');

with

Code: Select all

$this->cache->delete('category');
$this->cache->delete('search.categories');

Thanks to Q for mentioning the missed bit.

netpox wrote:My admin panel is still super slow when editing category. When I click on Save it takes a good 8-10 seconds to save. Any suggestions?

parcelscheaper wrote:Your website (autohut.ro) is not using opencart, I have checked by using builtwith.com, I assume you are simply trying to get some free backlinks to your store.
I would love to see a English language website that actually has over 1 million products on it, the hunt is on!

Thanks