Post by chrisnasah » Fri Apr 14, 2017 3:08 am

Hi

My store has 200 categories and 5000 products.

If I make one product part of two categories than the whole site slows down.

I am running 2.3.0.2 and am at loss what to do. Seems like a SQL issue but not sure how to troubleshoot and fix.

Any ideas?

Newbie

Posts

Joined
Sat Feb 11, 2017 11:32 pm

Post by thekrotek » Fri Apr 14, 2017 4:00 am

There's no SQL issue, because it doesn't matter, how many categories you assign to product - SQL query is the same. Always.

Professional OpenCart extensions, support and custom work.
Contact me via email support@thekrotek.com


User avatar
Active Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by chrisnasah » Fri Apr 14, 2017 4:35 am

Any advice what I should be looking at?

It's strange I did a fresh install of opencart and had exactly the same issue again.

I am lost at what it could be.

Newbie

Posts

Joined
Sat Feb 11, 2017 11:32 pm

Post by IP_CAM » Fri Apr 14, 2017 8:10 am

well, with 5K products on sale, you should be able to finance professional support.
Everything else would be just plain theory, at least, as long as you don't even show
a Site URL.
Just, to give you a 'free' hint, if you really plan, to get others to spare their valuable time... :'(
Ernie

Ernie's OpenShop v.1.75 + OpenCart v.1.5.6.5 LIGHT Test Sites with free responsive Themes
http://www.bigmax.ch/shop/ - http://www.ebikes.li - http://www.ipc.li/shop/ - http://www.openshop.li/shop/
Image


User avatar
Guru Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by sculptex » Sun Apr 16, 2017 5:55 pm

To help diagnose slow SQL queries, try using my suggestions in the following link. It would be good to run before and after adding a second category to pinpoint differences.
viewtopic.php?f=190&t=182883#p669689

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by chrisnasah » Fri Apr 21, 2017 7:29 pm

Thanks for the suggestions.

Issue got resolved after i removed the category count.

Newbie

Posts

Joined
Sat Feb 11, 2017 11:32 pm
Who is online

Users browsing this forum: Spud5 and 59 guests