Hello,
We are experiencing issues with the admin part of the website. I think the main reason is because we have about 3000 product options. When I enter in 'edit product' of a product that has 2-3 product options, it takes a while to load. We think that for the 2-3 option, OpenCart is going to make 2-3 mysql request getting the same information = the 3000 option for the 3 dropdown box displayed. Instead of doing 3 requests for the same, could we do just one?
Let me know if I'm mistaking or if anything else could cause this problem.
EDIT: Fixed, look at the bottom of topic.
This occurs sometimes. When you load the edit products page and go to the options tabs, one selectbox remains empty. You reload the page, all the selectbox are there, filled with the 3k+ options.
I'm not sure if this bug has been already reported. I've seen this in Geo Zones filled with Rest of the world or 48 Contiguous States. But this page would actually finish loading something. Not the options.
I'm not sure if this bug has been already reported. I've seen this in Geo Zones filled with Rest of the world or 48 Contiguous States. But this page would actually finish loading something. Not the options.
Does your store use vQmod ?
Can you increase max_execution_time and memory_limit in your admin/php.ini
Can you increase max_execution_time and memory_limit in your admin/php.ini
Yes we are using Vqmod. I've ran the script you've provided with the Intuitive Search extension that is suppose to make the database faster in some ways.
I am wondering how much memory_limit could affect the server's performance if we have multiple instances of the store running. How much mb would you recommend to set it?
I am wondering how much memory_limit could affect the server's performance if we have multiple instances of the store running. How much mb would you recommend to set it?
Try changing the following in your index.php
to
and in your admin/index.php
to
Code: Select all
require_once('./vqmod/vqmod.php');
$vqmod = new VQMod();
Code: Select all
require_once('./vqmod/vqmod.php');
$vqmod = new VQMod(false, true);
$vqmod->useCache = true;
Code: Select all
require_once('../vqmod/vqmod.php');
$vqmod = new VQMod();
Code: Select all
require_once('../vqmod/vqmod.php');
$vqmod = new VQMod(false, true);
$vqmod->useCache = true;
Changes has been done to my index files. I also have increased the phpinfo settings and I am still experiencing slow loading issues. Using Internet Explorer is deadly.
I am looking forward to have an answer to my original question.
Do you think for each product options, the script will pool the 3000 variants list, each time?
This means 9000 MySQL request + Insert result into select are done for a product that has 3 options. Take in mind we have products that have 20 + options. 60.000 queries is a lot for a single page to be loaded.
If this is true, it definitely needs to be changed.
Thanks for your help and time.
Cheers,
aurevilly
I am looking forward to have an answer to my original question.
Do you think for each product options, the script will pool the 3000 variants list, each time?
This means 9000 MySQL request + Insert result into select are done for a product that has 3 options. Take in mind we have products that have 20 + options. 60.000 queries is a lot for a single page to be loaded.
If this is true, it definitely needs to be changed.
Thanks for your help and time.
Cheers,
aurevilly
I believe there are changes being made in the current SVN to deal with this problem with options.
http://code.google.com/p/opencart/source/detail?r=668aurevilly wrote: Can I ask what makes you believe this? I checked the SVN and the product_option.php has been updated last Sep 28, 2011.
I just want to know if I should go ahead and develop a modifications or if I should wait...
Thanks
Sorry I have deleted the post because I answered too fast.
I downloaded the product.php and product_form.tpl
Works perfectly. I recommend anyone to update these files as it makes a significant difference in the loading time of the options.
Thanks a lot for your input UKSB.
Cheers,
J.
I downloaded the product.php and product_form.tpl
Works perfectly. I recommend anyone to update these files as it makes a significant difference in the loading time of the options.
Thanks a lot for your input UKSB.
Cheers,
J.
Hi, I have the same problem. Version 1.5.1.3aurevilly wrote:This occurs sometimes. When you load the edit products page and go to the options tabs, one selectbox remains empty. You reload the page, all the selectbox are there, filled with the 3k+ options.
I'm not sure if this bug has been already reported. I've seen this in Geo Zones filled with Rest of the world or 48 Contiguous States. But this page would actually finish loading something. Not the options.
Where I can get those files? Thanksaurevilly wrote:Sorry I have deleted the post because I answered too fast.
I downloaded the product.php and product_form.tpl
Works perfectly. I recommend anyone to update these files as it makes a significant difference in the loading time of the options.
J.
EDIT:
http://code.google.com/p/opencart/sourc ... n668&r=668
I seem to have the same problem as others have had before me, here is my situation:
It takes forever for the product edit page to load, roughly 5 minutes. I am using oc 1.5.2.1, vqmod 2.1.6 and have dependent options and options boost installed. I modified the both index.php to useCache as recommended above and http://code.google.com/p/vqmod/wiki/useCache.
The product has three options: Color, Width, and Length. The option Color has approx 60 values, width has 2 values, and length has 4 values. Does anyone know why it is taking so long to load this page? Let me know how I can gather further information if you need it.
Thanks a lot,
Tom
It takes forever for the product edit page to load, roughly 5 minutes. I am using oc 1.5.2.1, vqmod 2.1.6 and have dependent options and options boost installed. I modified the both index.php to useCache as recommended above and http://code.google.com/p/vqmod/wiki/useCache.
The product has three options: Color, Width, and Length. The option Color has approx 60 values, width has 2 values, and length has 4 values. Does anyone know why it is taking so long to load this page? Let me know how I can gather further information if you need it.
Thanks a lot,
Tom
Could be dependent options though usually you need thousands of options values in your store before you start seeing slowdowns. If you want to send temp log in credentials to the support email listed in the readme I'll take a look.
-Ryan
I'll need to take a look at your site if it's web accessible. Create a custom user for me that you can delete/disable later. You don't have to give it Top Administrator group rights if you don't want but I will at least need access/modify permissions for catalog/product, catalog/option, and module/vqmod_manager if you have VQMod Manager installed.
-Ryan
I normally hate replying to old threads but yup this is the exact problem i have although mine is subsequently worse with Dependant options installed and active the load time in the end gives out and laughably i have 2 products so far although each one has 400 options ish
Who is online
Users browsing this forum: No registered users and 85 guests
