Woocommerce Admin end incredibly slow almost unusable

Phew! Thanks to an amazing Indian woman from freelancer.com the problem is fixed. She said it was a database issue. She fixed in 10 minutes what my hosting company has been trying to figure out for 2 days haha.

Can you elaborate on what she claimed was the “database issue” that slowed your site so much? Unless something was setup wrong to begin with, usually I’ve not seen quick fixes for obscenely slow admins. For example, the gist below is what I had to use to speed up the site because comments and order counts loading on every page load were taking 6+ seconds on multiple queries.

https://gist.github.com/pmgarman/d64c768754dbc0ff5f49

With this code I went from ~10-20s load times depending on the page to typically under 1s load times on a database that is somewhere between 35-50GB depending on the size of the sessions table (yes, the sessions table has reached over 15GB in size).

I didn’t ask for too much detail because i was so excited that it worked but what she said was there were problems in the WP total cache. She had to deactivate it, reactivate it, and and change settings. The specifics for what the problems in the total cache were and what she changed in the settings i don’t know.

Interesting plugin you have there. So if I were to install that it would speed up my admin page load times even more? Because even though everything is working fine again and loading like normal, I’d still like it to be a little faster and was going to look for any plugins out there that speed up the admin side of the site.

I was experiencing this slow admin issue running WP 4.4.1, Woocommerce 2.5.1 and found the culprit to be my Stamps.com plug-in. Disabling the Stamps.com plug-in fixed the speed issue. Just today a new update was released from plug-in author for Stamps.com that fixed the plug-in so I can reactivate it without slow down.

I ran into the same problem today, Frontend is fine but WP backend was slow as heck.

This is WP 4.4.2 with customized Enfold theme, running WooCommerce 2.5.5.
I disabled all plugins, reactivating them one after another and, wouldn’t you know it… WooThemesHelper 1.6.1 was the issue. Disabled it and the backend runs like a charm again.

Hi,

PLEASE PLEASE Help!!!! We have a Magazine Site with 600.000 Unique Clients and nearly 2.000.000 visits a month. We decided to give customers the chance to read special Content for a little amount… So we got the WooCommerce Memberships, WooCommerce One Page Checkout, WooCommerce PDF Invoices & WooCommerce Subscriptions Addons.

On our staging/dev Site – everything was working fine.

Now on our live Site – you can imagine what is happening. In 2 Weeks our options table was bloated up to 1.200.000 Rows.
Every few hours nearly 10.000 more. We can′t deactivate it, because over 400 Customers are already registered. Cron job does not matter, because of the countless DB Queries. The Backend gets so slow, that our Authors can′t work as they would like to. BTW – WooCommerce destroys our Content Marketing Tool – CoSchedule Plugin.

It is no solution to delete expired transients every few hours. We know why they exist. But we only have a subscription plan – no webshop with “real” Products. We dont need timeout_geoip, external_ip_address, geoip etc. 300 queries per second… It is too much.
Of course we deactivated everything we could in the backend.

We are already on a dedicated server with ssd and enough resources…

So, how can we get rid of this massive problem!?!?

Please Help!!!
MC

Here our Status Report:

`
### WordPress Environment ###

Home URL: https://—
Site URL: https://—
WC Version: 2.5.5
Log Directory Writable: ?
WP Version: 4.5.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
Language: de_DE

### Server Environment ###

Server Info: Apache
PHP Version: 5.5.36
PHP Post Max Size: 20 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
SUHOSIN Installed: –
MySQL Version: 5.5.49
Max Upload Size: 20 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?
WCS_DEBUG: ?

No
Abonnements Art: ?

Live

### Database ###

WC Database Version: 2.5.5
:
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_termmeta: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?

### Active Plugins (46) ###

Hide My WP: von AUB Media – 5.01
Admin Columns Pro: von AdminColumns.com – 3.8.6.1
Advanced Custom Fields PRO: von Elliot Condon – 5.3.8.1
Ambrosite Body Class Enhanced: von J. Michael Ambrosio – 1.3
bananacontent: von Vladislav Melnik
Jonas Breuer – 1.9.1

iThemes Security: von iThemes – 5.4.5
Categories Images: von Muhammad Said El Zahlan – 2.5.3
Category Checklist Tree: von scribu – 1.3.2
Cookie Notice: von dFactory – 1.2.35
CoSchedule by Todaymade: von Todaymade – 2.4.9
Cron GUI: von Simon Wheatley – 1.03
Delete Expired Transients: von WebAware – 2.0.4.1
Disqus Comment System: von Disqus – 2.85
Easy WP SMTP: von wpecommerce – 1.2.3
Google Analytics by MonsterInsights: von MonsterInsights – 5.5
Heartbeat Control: von Jeff Matson – 1.0.3
Quform: von ThemeCatcher – 1.7.9
Live Blogging: von Chris Northwood – 2.2.5
MobiLoud: von Pietro Saccomani – 3.3.9
P3 (Plugin Performance Profiler): von GoDaddy.com – 1.5.3.9
Post-Duplizierer: von Metaphor Creations – 2.17
Simple 301 Redirects: von Scott Nellé – 1.07
Single Category Permalink: von Scott Reilly – 2.1.2
TotalPoll: von WPStore – 2.6
Verkehrsstrafen-Rechner: von — – 0.1
WooCommerce Memberships: von WooThemes / SkyVerge – 1.6.0
WooCommerce One Page Checkout: von Prospress Inc. – 1.2.7
WooCommerce PDF Invoices: von Andrew Benbow – 3.2.1
WooCommerce Subscriptions: von Prospress Inc. – 2.0.15
WooCommerce: von WooThemes – 2.5.5
WooCommerce PayUnityCw: von customweb GmbH – 4.0.14
WooThemes Helper: von WooThemes – 1.6.2
WordPress SEO News: von Joost de Valk – 1.1.1
Yoast SEO Premium: von Team Yoast – 3.2.2
WP Category Permalink: von Jordy Meow – 2.2.8
WP-Pro-Quiz: von Julius Fischer – 0.37
WP Rocket: von WP Rocket – 2.8.2

### Settings ###

Force SSL: ?
Currency: EUR (€)
Currency Position: left
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2

### API ###

API Enabled: ?
API Version: 3.1.0

### WC Pages ###

Shop-Basis: #187664 – /shop
Warenkorb: #187665 – /warenkorb
Kasse: #187666 – /kasse
Mein Konto: #187667 – /mein-konto

### Taxonomies ###

Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

### Theme ###

Name: …
Version: 4.0
Author URL: https://—
Child Theme: ? – Wenn du WooCommerce mit einem Theme
das du nicht selbst entwickelt hast
an eigene Bedürfnisse anpasst
dann empfehlen wir die Verwendung eines Child Themes. Siehe Wie du ein Child Theme erstellst (engl.)

WooCommerce Support: Nicht angegeben

### Templates ###

Overrides: …/woocommerce/checkout/review-order.php
…/woocommerce/myaccount/form-add-payment-method.php
…/woocommerce/myaccount/form-edit-account.php
…/woocommerce/myaccount/form-edit-address.php
…/woocommerce/myaccount/form-login.php
…/woocommerce/myaccount/form-lost-password.php
…/woocommerce/myaccount/my-account.php
…/woocommerce/myaccount/my-address.php
…/woocommerce/myaccount/my-downloads.php
…/woocommerce/myaccount/my-orders.php
…/woocommerce/myaccount/view-order.php

Just a quick thanks to Patrick for his github plugin. Solved big delays we were seeing on two Woo sites. Great work, sir!

I doubled my performance by disabling the Yoast Premium SEO plugin, now looking into disabling MaxGeoIP on that page

I doubled my performance by disabling the Yoast Premium SEO plugin, now looking into disabling MaxGeoIP on that ajax page

I was experiencing slow checkout times while the credit card was processing, up to 20 seconds. I disabled Geolocate in WooCommerce settings and this improved, but not as much as I would like. PayPal was faster, but I prefer Stripe. My server is amazingly fast https://agentplug.com the only slow issue is checkout. I use Yoast as well, I will disable all plugins and try again. If we did want an expert opinion, who would you recommend?