Hi Everyone,
I'm working on a website for my client which is almost complete.
currently I have around 300+ categories/subcategories and around 700 products
I have to add around 5000 more products in coming weeks.
I chose opencart because I found it very nice and user friendly, however the biggest issue I'm having is that the website is loading too slow.
I followed the instruction in this post and removed the categories drop down from the list.
http://forum.opencart.com/viewtopic.php ... 811#p61811
Before applying this method Website loading time was 27 seconds (http://www.webpagetest.org/result/101124_5YM/)
After Aplying the above method the time reduced to 19 seconds (http://www.webpagetest.org/result/101124_618/)
but this is still very slow.
Can any one tell me what is the actual issue which is causing the website to load slow.
here is the link of website
http://client.euwebdesignuk.co.uk/malo_products/final/
you could follow the directions at this page to see if mysql is slowing things down and if so what queries are causing the problem.
http://forum.opencart.com/viewtopic.php?f=121&t=22048
http://forum.opencart.com/viewtopic.php?f=121&t=22048
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
I thought you cached the category lookup.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Thanks for your replies,
Can you please suggest what do I have to do in order to resolve this issue.
Do I need to reduce the number of categories?
I used import/export module and created all the categories myself in the excel sheet. it was hard to manage so many categories and I had to give them long integer id's in order to make each id unique.
Can you please suggest what do I have to do in order to resolve this issue.
Do I need to reduce the number of categories?
I used import/export module and created all the categories myself in the excel sheet. it was hard to manage so many categories and I had to give them long integer id's in order to make each id unique.
First thing I would do is to disable the category module and comment out the following line in common/header.php (around line 118) to check if it is really category issue.
I have loaded my site with 200+ categories and 11,300+ product and it takes 10-15seconds. Check out at http://www.sansdirect.com and see if you see the same response.
Also, check your error log for any script errors and warnings. This will reduce the response time too.
Code: Select all
$this->data['categories'] = $this->getCategories(0);Also, check your error log for any script errors and warnings. This will reduce the response time too.
Extensions: Multi-vendor extension
Shipping Modules: SuperShip Pro
Multi-Vendor Marketplace:Opencartmarketplace.com
IceCat to Opencart: Import millions of IceCat products to Opencart
ahh didn't realize that maybe we should cache that too.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Actually I'm wrong. The caching IS on all categories. But I think there might be an issue with empty categories. Since the cache returns an empty array for categories with no subs, it requeries the database as it reads "empty array" and "false variable" the same.
So try this
1. EDIT: catalog/model/catalog/category.php
2. FIND:
3. REPLACE WITH:
So try this
1. EDIT: catalog/model/catalog/category.php
2. FIND:
Code: Select all
if (!$category_data) { Code: Select all
if (!$category_data && !is_array($category_data)) { 
Qphoria wrote:Actually I'm wrong. The caching IS on all categories. But I think there might be an issue with empty categories. Since the cache returns an empty array for categories with no subs, it requeries the database as it reads "empty array" and "false variable" the same.
So try this
1. EDIT: catalog/model/catalog/category.php
2. FIND:3. REPLACE WITH:Code: Select all
if (!$category_data) {Code: Select all
if (!$category_data && !is_array($category_data)) {
I did it on my site Q and did the test below hope it helps out. but you may have something there I have a few empty categories as I am still stocking my store I'm keeping the inventory lite just to make sure.
now I am doing some testing right now as I am writing this
Test #
#1.) popup category mod disabled no side category option running.
Results : site running lighting fast
#2.) enabling popup category mod in cached mode
Results : large slow down 30sec page load times
#3.) enabling popup category mode non cached mode
Results : much faster 5sec page load times
seems if you disable the cache mode in the popup category mod it works much better. I'll do further testing on my half to make sure of the results. but right now the results look promising.
I recently moved to the island formally owned by Dr. Moreau and currently live there lost in a ocean of computer code with my cat Nigel... help us!!!
popup category module is the mod I referred to, the author has a cache mode for it. But it seems the cache mode does more harm then good. http://www.opencart.com/index.php?route ... order=DESCQphoria wrote:not sure what the popup category mod is but I assume they are using the same category lookup in the model. Did my change above improve anything?
As of right now I think this is the solution Q. My site is running much faster and very efficient. So I'm gonna finishing loading my stock onto my site to make sure the slow down bug has been squashed.
I recently moved to the island formally owned by Dr. Moreau and currently live there lost in a ocean of computer code with my cat Nigel... help us!!!
Well been running it for a couple of hours and its been running well. Thanks Q I think this is the solution!!
but I still haven't tested it on a standard site installation yet, since I have made some modifications to my base site installation. I have added a few modules, updated to 1.4.9.2 and added some code to my site from others in the forums that was trying to help on this issue. I know your fix had the greatest impact on resolving the issue but not sure if it was just part of the puzzle. So I guess the next step is to test this on a standard install of 1.4.9 with 300 categories and see what happens. Then move to add it to 1.5 and to a patch for 1.4.9 for others that are experiencing the same issue.
Again thanks Q !!!
but I still haven't tested it on a standard site installation yet, since I have made some modifications to my base site installation. I have added a few modules, updated to 1.4.9.2 and added some code to my site from others in the forums that was trying to help on this issue. I know your fix had the greatest impact on resolving the issue but not sure if it was just part of the puzzle. So I guess the next step is to test this on a standard install of 1.4.9 with 300 categories and see what happens. Then move to add it to 1.5 and to a patch for 1.4.9 for others that are experiencing the same issue.
Again thanks Q !!!
I recently moved to the island formally owned by Dr. Moreau and currently live there lost in a ocean of computer code with my cat Nigel... help us!!!
just out of curiosity could someone who is having the slowness problems try adding an index on the parent_id field of the category table and see if that helps?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Wow! I tried this, and my site loaded almost instantly on every click. Incredible.cartpro wrote:First thing I would do is to disable the category module and comment out the following line in common/header.php (around line 118) to check if it is really category issue.
Code: Select all
$this->data['categories'] = $this->getCategories(0);
The site seems to work fine and nothing is broken that I can tell... what does this line actually do? Can I just leave it commented out?
Glad you found the issue.
What I would do is, cache the rendered category menu instead of caching individual category queries. That means, you will disaply all the categories in a multi-level menu. Check out menu on the header bar on my site http://www.sansdirect.com
What I would do is, cache the rendered category menu instead of caching individual category queries. That means, you will disaply all the categories in a multi-level menu. Check out menu on the header bar on my site http://www.sansdirect.com
Extensions: Multi-vendor extension
Shipping Modules: SuperShip Pro
Multi-Vendor Marketplace:Opencartmarketplace.com
IceCat to Opencart: Import millions of IceCat products to Opencart
Your site is painfully slow.cartpro wrote:Check out menu on the header bar on my site http://www.sansdirect.com
Why don't you use the removal of:
Code: Select all
$this->data['categories'] = $this->getCategories(0);yourself?
Who is online
Users browsing this forum: No registered users and 102 guests
