This topic has been marked as not resolved.
Viewing 6 posts - 1 through 6 (of 6 total)
- You must be logged in to reply to this topic.
This topic has 3 voices, contains 5 replies, and was last updated by TB Support 4386 days ago.
ThemeBurn Support › Forums › OpenCart Themes › Shoppica OpenCart Theme › New install, 1.5.1.1 + Shoppica + 700 categories = Performance issue?
This topic has been marked as not resolved.
Hi, My installation of 1.5.1.1 was working fine on my new development environment until I restructured my categories to add more tiers. Now I have massive performance degradation. Summary Info:- - New, clean install All was working fine until I recently made some seemingly trivial changes. I have successfully imported a list of approximately 1500 products. The products are related to English Premiership Football teams so I will use actual examples. Example of original TEST Category tree Apart from too many products being in a single category, this worked absolutely fine and page load times were as expected. Example of New (more organised) category tree I have only changed the category structure and yet page load times have massively degraded. Total number of products 1426 I don’t consider this to be a massive load, nor abnormal configuration. I originally assumed that this issue related to MySQL queries / MySQL indexing surrounding categories on Open Cart and how they are handled from parent to child but maybe only when 3,4 or more layers exist but after testing with the default theme it appears that Shoppica might be slowing things down. Open Cart is definitely slower with these categories but when I re-apply Shoppica theme page load times almost double. Could the top menu category tree be causing a problem? I intend to add some debugging to test further and disclose page load times and any problem MySQL queries but this may take some time. I will update thread once implemented if I find anything of interest. Has anyone else noticed performance degradation on 1.5.1.1 with Shoppica when adding this many categories which are 3 or more tiers deep? Thanks in advance! Gary |
|
September 2, 2011 at 2:51 pm #1368
|
|
Hi gcheers, and thank you for the detailed explanation. As there are quite a few things to check in order to provide helpful answer to your question, we’ll delay it for day or two. Hope this is not deal breaker for you. Best Regards, ThemeBurn team |
|
September 2, 2011 at 6:21 pm #1429
|
|
Okay, firstly could you try the following modifications and report the results here. 1. Disable the ‘Show brands in the main menu’ option in the Shoppica CP if you have enabled it and see if this makes a difference. 2. Execute the followin queries agains your database (through phpmyadmin I guess): You will need to register in order to post topics and read replies in the ThemeBurn.com support forums!
Waiting to hear from you. Best Regards, ThemeBurn team |
|
September 5, 2011 at 4:52 pm #1510
|
|
Also, I know it could sound ridiculous, but if it is possible, you could send us database dump to execute some queries against it. Just a suggestion. |
|
September 5, 2011 at 4:56 pm #1511
|
|
Hello, I have a question. What do those sql queries do? My website load time seems to fluctuate between 5 seconds to 20 seconds. Will running this help? Thanks |
|
May 1, 2012 at 3:49 am #8488
|
|
You can safely run these queries in phpmyadmin. They’ll add indexes without changing any database structure or data. The indexes help performance. |
|
May 1, 2012 at 9:56 am #8494
|