OpenCart getCategories() function slow page load
$10-30 USD
착불
As you can see in [url removed, login to view], the page load speed is very slow.
This is due the categories in left side.
The fault is in here:
public function getCategories($parent_id = 0) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND [url removed, login to view] = '1' ORDER BY c.sort_order, LCASE([url removed, login to view])");
return $query->rows;
}
The server DOES HAVE Memcache.
If you are able to fix this, please post in comments FIRST WORD "Understood." and details. If the first word is not the one mentioned, you're assumed as spamer and ignored.
프로젝트 ID: #5036853
프로젝트 소개
이 일자리에 대한 프리랜서 6 명의 평균 입찰가: $84
Understood Hi, I can optimize the left category menu. But this doesnt mean that it will speed up your overall website. Thanks, Harsh
"Understood" - i'm here for you. Opencart expert here. Let's start with me right now ! Thank you so much !
Hello, I'm Matt and I specialize in performance optimization of PHP/MySQL/HTML applications, including OpenCart. Most of my projects are related solely to performance optimization. Some of my past work: https://www 기타
Understood. Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like 기타
