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
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.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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 ?
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
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.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
LOL - I will tell him !paulfeakins wrote: ↑Fri May 17, 2019 5:56 pmYou 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.
Thanks Straightlight, 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:straightlight wrote: ↑Sat May 18, 2019 1:42 amThis commit can also be useful to know as an information: https://github.com/opencart/opencart/is ... -487515608
viewtopic.php?t=211273
------------------------------------------
Retro gifts, toys, games and accessories
https://www.retroactives.com/
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
I have investigated this problem and have discovered that CORE OpenCart makes a heap re-iterative calls, reloading product items many times during a page load.
For example, Cart\Cart >getProducts() gets called numerous times just to load the home page.
There is no cache so every call to Cart\Cart >getProducts() reloads the entire cart from scratch. The more cart items you have, the more the load time starts to compound.
This is quite amazing considering the maturity and claimed scalability of OpenCart and a lot of opencart experts claiming nothing is wrong with the core code.
Also, Cart\Cart >getProducts() gets called by other simple sub-routines:
Cart\Cart->getTaxes()
Cart\Cart->countProducts()
Cart\Cart->hasShipping()
Cart\Cart->getSubTotal()
Thanks to Mikhail at liveopencart, he has produced a ocmod that basically brings down page load times with carts loaded with many products from 10's of seconds (in my case +25 seconds for +130 cart items) down to seconds (3 seconds for me).
Anyone wanting the fix please contact him at "support at liveopencart.com".
Nobody says anything about OC 3 stability, everybody says quite the opposite actually. And yes, there's nothing bad in the code, basic cart data is saved in database, which is more than enough. 130 products in the cart is a VERY specific situation, which should be addressed personally. If you have 500K+ products in your store, you will have more slowdowns in different situations and all of them you will have to address personally. OpenCart is NOT here to blame, no matter how badly you want it.foobarac wrote: ↑Fri Jun 14, 2019 8:05 amThere is no cache so every call to Cart\Cart >getProducts() reloads the entire cart from scratch. The more cart items you have, the more the load time starts to compound.
This is quite amazing considering the maturity and claimed scalability of OpenCart and a lot of opencart experts claiming nothing is wrong with the core code.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
130 items was used as a bench mark, but definitely the performance starts to suffer from about 20 items in the cart.thekrotek wrote: ↑Fri Jun 14, 2019 1:36 pmNobody says anything about OC 3 stability, everybody says quite the opposite actually. And yes, there's nothing bad in the code, basic cart data is saved in database, which is more than enough. 130 products in the cart is a VERY specific situation, which should be addressed personally. If you have 500K+ products in your store, you will have more slowdowns in different situations and all of them you will have to address personally. OpenCart is NOT here to blame, no matter how badly you want it.foobarac wrote: ↑Fri Jun 14, 2019 8:05 amThere is no cache so every call to Cart\Cart >getProducts() reloads the entire cart from scratch. The more cart items you have, the more the load time starts to compound.
This is quite amazing considering the maturity and claimed scalability of OpenCart and a lot of opencart experts claiming nothing is wrong with the core code.
And I was referring to the comments made above including yours pointing it to be my problem. Now you are saying the opposite.
There is no expectation of warranty on my side I have made about 100 code fixes already. However, if you bothered to understand what I am saying, basic cart data doesn't have to be rebuilt 6 times (standard OC 3 code and theme) because you are changing a screen.
The process and code around the cart processing should be refactored but that's up to the keepers.
At least now the problem is documented on the forum and a fix is available.
Definitely NOT. Works perfectly with 20-40 items for me. Didn't try to add more.
Never said the opposite.
Considering that it fits 99.9% of store owners, I doubt it requires any fixing.
Don't see any fix, only see a reference about some guy, who supposedly have a fix.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
oh
It's up to the developer to release the code, he owns it.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com