We went from opencart 2.3.0.2 to 3.0.3.7
Then upgraded the day 3.0.3.8 came out.
We ditched journal theme and using Antropy CSS only.
The front page our website is running great. Very fast.
The admin is so slow. Like going from order dashboard (set to only 10 orders in the list) is slow.
Going BACK to dashboard, even slower.
Our other 2.3.0.2 store is much quicker admin wise.
We are on a VPS cloud server, resources is not an issue. plenty of memory and storage.
How can I investigate?
Hello, Have you checked your site speed or clear cache from your site? Sometimes upgrade create unusual files. If you need I can check your backoffice and help you out about your issues. Thanks
Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com
Webinar : Power up Your holiday season marketing with the Automation tool
Did it happen right after the upgrade to 3.0.3.8?
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Thank you Krotek.
To be honest, I cannot recall, but I believe it go slower after going from 3.0.3.7 to 3.0.3.8
Yes I cleared local cache, firewall cache.
It is also slow in developer copy site.
To be honest, I cannot recall, but I believe it go slower after going from 3.0.3.7 to 3.0.3.8
Yes I cleared local cache, firewall cache.
It is also slow in developer copy site.
Self Taught Opencart User & Developer Since 2010.
In this case it's impossible to tell anything particular without looking into the issue personally. I can take a look if you wish.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
I'm happy to pay you to take a look. I do believe it could be a database issue?
The upgrade of the database may not have gone correctly. For example, we noticed that the customer table did not have a primary key
But it does in the 2.3.0.2 database.
We can create a dev site or you can remote screen share. Please PM me and let's chat.
Self Taught Opencart User & Developer Since 2010.
I don't use this forum's PM, it's ugly. Please, send me an email or message in Skype instead.Rainforest wrote: ↑Thu Sep 09, 2021 12:41 amWe can create a dev site or you can remote screen share. Please PM me and let's chat.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
hahah agreed!thekrotek wrote: ↑Thu Sep 09, 2021 12:50 amI don't use this forum's PM, it's ugly. Please, send me an email or message in Skype instead.Rainforest wrote: ↑Thu Sep 09, 2021 12:41 amWe can create a dev site or you can remote screen share. Please PM me and let's chat.
Self Taught Opencart User & Developer Since 2010.
Could be the issue because Primary Keys are automatically indexed and indices are required for the db to run quickly.Rainforest wrote: ↑Thu Sep 09, 2021 12:41 amI'm happy to pay you to take a look. I do believe it could be a database issue?
The upgrade of the database may not have gone correctly. For example, we noticed that the customer table did not have a primary key
But it does in the 2.3.0.2 database.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Also this is great to hear!
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Try enabling the SASS cache (gear icon in the top-right of the dashboard):Rainforest wrote: ↑Wed Sep 08, 2021 8:03 pmThe admin is so slow. Like going from order dashboard (set to only 10 orders in the list) is slow.
Going BACK to dashboard, even slower.
Our other 2.3.0.2 store is much quicker admin wise.
Yes , it was a db issue. I learned that during the upgrade process some indexes and primary keys did not transfer ( oc. 2.3.0.2 ---->3.0.3.7 --> 3.0.3.paulfeakins wrote: ↑Fri Sep 10, 2021 6:08 pmCould be the issue because Primary Keys are automatically indexed and indices are required for the db to run quickly.Rainforest wrote: ↑Thu Sep 09, 2021 12:41 amI'm happy to pay you to take a look. I do believe it could be a database issue?
The upgrade of the database may not have gone correctly. For example, we noticed that the customer table did not have a primary key
But it does in the 2.3.0.2 database.
In addition, one or two extensions, event though uninstalled and deleted left db tables. One of those tables kept multiplying in size as we used the admin section 
We removed the table, reinstalled the extension and all is good.Ha, and yes front end looks nice and is fast!
Self Taught Opencart User & Developer Since 2010.
Who is online
Users browsing this forum: No registered users and 39 guests
