Post by foobarac » Thu May 16, 2019 4:03 pm

OC 3.0.2.0
PHP 7.1 (was 5.6)
Theme: Basel
62 Products (including options)
20 Categories
system setting to count products for categories - turned off
Gzip and Apache caching turned on.
Database has been refreshed, all session and cart tables have little in it.

My webshop (still under UAT) performs extremely fast. Page loads and adds to carts are extremely quick (like 1-2 second load times).

However, the more you add to the cart, the slower it gets. By the time you get to 20 items its like 15-20 second page loads. Likewise if you make a change to the cart (delete an item) it takes around 15-20 seconds but starts to speed up the more you delete.

There are no errors coming up in the error.log and I have tried to research here and on the web but nothing comes up.

This purely looks like a problem just with the cart processing.

Any ideas or help on how solve this ?

Thanks,

Anthony
Last edited by foobarac on Mon May 20, 2019 5:40 am, edited 1 time in total.

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by paulfeakins » Thu May 16, 2019 5:32 pm

foobarac wrote:
Thu May 16, 2019 4:03 pm
However, the more you add to the cart, the slower it gets. By the time you get to 20 items its like 15-20 second page loads. Likewise if you make a change to the cart (delete an item) it takes around 15-20 seconds but starts to speed up the more you delete.
And does this happen if you switch back to the default theme? If so the problem is with your theme and you should contact the theme developer.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by thekrotek » Thu May 16, 2019 6:25 pm

There're definitely no issues with cart database queries in OpenCart. 20 items is a very, very small number, it can not slow down the queries.

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by foobarac » Thu May 16, 2019 7:56 pm

Hi Paul,

Was in the process of building a copy on a test site. Disabled the theme and yes it's faster.

What I should really ask if there are any ideas (besides pinging the theme developer which I have done) on how to get an AJAX based theme performing quicker ?

Any changes in the config.php or .htaccess files or any other suggestions ?

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by thekrotek » Thu May 16, 2019 10:28 pm

foobarac wrote:
Thu May 16, 2019 7:56 pm
What I should really ask if there are any ideas (besides pinging the theme developer which I have done) on how to get an AJAX based theme performing quicker ?
Depends on which AJAX requests are made. Sometimes database indexing/caching helps.

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Fri May 17, 2019 5:56 pm

foobarac wrote:
Thu May 16, 2019 7:56 pm
What I should really ask?
You should ask them to reconsider their career as a developer if they can't make an AJAX request that returns 20 database rows run quickly.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by straightlight » Sat May 18, 2019 1:42 am

This commit can also be useful to know as an information: https://github.com/opencart/opencart/is ... -487515608

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.

F. Rules:

- viewtopic.php?f=176&t=200480
- viewtopic.php?f=176&t=200804


Regards,
Straightlight


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by foobarac » Sun May 19, 2019 1:11 pm

paulfeakins wrote:
Fri May 17, 2019 5:56 pm
foobarac wrote:
Thu May 16, 2019 7:56 pm
What I should really ask?
You should ask them to reconsider their career as a developer if they can't make an AJAX request that returns 20 database rows run quickly.
LOL - I will tell him !

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by foobarac » Sun May 19, 2019 1:32 pm

straightlight wrote:
Sat May 18, 2019 1:42 am
This commit can also be useful to know as an information: https://github.com/opencart/opencart/is ... -487515608
Thanks Starlight, although a different problem being reported, it is centered around the cart and how and when it is updated by OC. It appears some work may need to be done around this to improve the performance especially when you have a loaded cart:

viewtopic.php?t=211273

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by JazzBlueRT » Sun May 19, 2019 3:46 pm

PHP 5.6 is no longer supported by the PHP team . OC 3 runs fine on PHP 7.2. You will get a substantial performance boost with PHP 7+.

------------------------------------------
Retro gifts, toys, games and accessories
https://www.retroactives.com/


User avatar
Newbie

Posts

Joined
Mon Nov 06, 2017 1:34 am

Post by foobarac » Mon May 20, 2019 5:38 am

Yes I have moved to PHP 7.1 and it has improved the situation.

But with a loaded cart you can still get a performance hit when you change pages or try anything processing the cart.

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm

Post by thekrotek » Mon May 20, 2019 6:19 am

I'm afraid, the issue is on your side. Probably happens on a certain server configuration. I've added 30+ items to cart and it loaded just fine, didn't notice any drop in performance. Tested it on OC 3, PHP 7.2.

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: megahellstorm and 26 guests