OpenCart Community

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.

What is your opencart version ?

Version 1.5.1.3

Sorry should have mentioned in 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.

We're kind in a rush. Any help would be appreciated. We are willing to pay if someone has this fix.

Does your store use vQmod ?

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?

Try changing the following in your index.php

to and in your admin/index.php
to

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 believe there are changes being made in the current SVN to deal with this problem with options.

aurevilly 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

http://code.google.com/p/opencart/source/detail?r=668

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.

aurevilly 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.

Hi, I have the same problem. Version 1.5.1.3

aurevilly 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.

Where I can get those files? Thanks

EDIT:

http://code.google.com/p/opencart/sourc ... n668&r=668

I Update with 2 new files BUT in my istallation the problem is now bigger: product page freeze...

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

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.

Thanks, where would I find the logs that you need?

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.

Hello.

I have the same problem. Links to files has expired :/

can you update links or tell me oder way to fix this problem?

Regards,

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