OpenCart Community

Hello, I'm developing a site which is having approximately 475 products and over 2000 options, every product has at most 20 options.. The presence of these 20 options per product makes the admin side of the site very slow when editing a product, when switching through the tabs in product's edit screen, it takes very long time to load the separate tabs. This way it is extremely slow when entering the products. I couldn't find any solution to this problem on the internet. Tried adding INDEXING to the db for some tables, but it didn't help with anything at admin's end of site.
If anyone has an idea? Highly appreciated.. I simply don't have any ideas what to do about it...
Thank you..

Seems like no one had a similar problem... I am using OpenCart version 1.5.6.4

Hi itdes,

There are quite a few database optimisations you can try. If you want someone to take a look for you, PM some details.

- Mel


Sent from my iPad using Tapatalk

first check if your database is on localhost or remote sql
when on loval host, try to change config.php located in folder admin to replace localhost with ip adres 127.0.0.1
if on remote sql server ask your hoster the ip adres of the sql server and use this in config.php.

also consider asking your host to transfer to a server with localhost.

next option is improving database ateucture and adding indexes to all tables
use the php file here and let it do its magic, it has a great bemefit on speed both admin and front of site.

Thank you for your replies and suggestions!
I tried replacing localhost with 127.0.0.1, but the admin side didn't work faster.. Just when trying to switch between the tabs in product's edit mode, the swithching itself and entering information becomes very slow. Is this a normal behavior or I'm the only one with this issue?
I'm going to try again adding indexes to the tables in the database, but I tried before and there wasn't a change at all, so I'm wondering what could be the reason and the solution.

Hi itdes,

that does sound strange. Without acces to the code, it's really hard to offer more advice. Can you tell us the URL of the site so I can do a speed test ? Obviously it won't help with the Admin side of things, but if there is an underlying issue with your site it may be related.

Otherwise PM me some details and I'll take a look under the covers.

- Mel

Hello,

I found out that the slow loading in product edit mode is caused by the number of option values per product. When I have more than 10 option values, even less than that, when I open a product for editing it is extremely slow, the browser page freezes for some time, and it could load after 3 minutes or so. Unfortunately, I can't provide a link to the site, because I'm not the owner of the site.
I found a similar topic here -> http://forum.opencart.com/viewtopic.php ... 1&start=20 but no solution had been provided...

Is there anyone who knows how thins thing could be fixed and what is the issue even? In total I have 3000 option values, in the whole store, and 450 products..The version of OpenCart that I use is 1.5.6.4

Any idea is highly appreciated, I was trying to fix this for so long time.. The problem is general in opencart, it is not particular just in my case.

just in case, so you know where to find the best DB-Tools.

The ATOMIX Version is best, but it cannot change the engine from InnoDB to MyISAM (no reason to do it, actually).
The French OVERCLOCKED OC-Version has such a two-way Admin Option built-in as well, but, to my present knowledge, no FULL Indexer, the upmost important OC-Performance feature! Just to mention it, better ALL than not enough...

The Second Version works as well, but produces an ugly looking error Message, i.E., if it cannot 'convert' a Table like >>>os1_translate<< as shown, for some reason. But this is a minor detail, and will hopefully be modified in an updated Mod. I may have to check on the DB-Content Language Translation Mod involved, or then, remove it, I don't like to have 1 only MyIsam-driven Element in my DB.

Try to get 'em ALL indexed AND to use the same (INNODB or MyISAM) ENGINE, at least. Every SWITCH is lost time. The Atomix Turbo.php does it all, and displays detailled results as well. Reindex the DB again after installing DB-related MOD's, you never know...

Good Luck

Ernie
openshop.li

Thanks for your suggestion, I am definitely gonna give it a try.

Hello Itdes,

I have same problem like you with many options ( option_value_id ) and slow product opening in admin panel. Have you found any decision?