|
Lauren Slocum
|
December 14, 2017 at 5:52 am
Our site (www.checkoutri.com) is one of only 7 sites on the VPS, and as of lately, it runs extremely slow. The rest of the sites don’t seem to have any issues.
Any ideas?
|
|
Josh
|
December 14, 2017 at 8:37 am
Hi there,
This is only a guess: Can you check the wp _options table to see what’s the biggest option records that get autoloaded?
If you know how to use phpmyadmin or another database tool for your VPS, you’d do a query like this:
SELECT option_name, CHAR_LENGTH (option_value) as Char_Length FROM wp_options WHERE autoload='yes' ORDER BY CHAR_LENGTH(option_value) DESC;
If there’s a specific option that gets listed there that’s upwards of 1MB in characters then that might be what’s slowing down the site.
|
|
Lauren Slocum
|
December 14, 2017 at 9:28 pm
ee_core_routes has a char_length of 2014727. That’s the #1 entry. The #2 entry is ee_active_messengers has a char_length of only 25606.
How do we correct this issue. ee_core_routes has close to 2MB in characters.
Thank you for your help 🙂
|
|
Josh
|
December 15, 2017 at 7:41 am
You can actually delete that ee_core_routes option. It’s not used, and should have been deleted but somehow wasn’t deleted.
|
|
Lauren Slocum
|
December 15, 2017 at 10:39 am
just delete the table or delete it in the code? If in the code, where?
Thanks
|
|
Josh
|
December 15, 2017 at 10:54 am
You delete the single option from the options table. You do not delete the table, and you do not delete any code from anywhere.
|
|
Lauren Slocum
|
December 15, 2017 at 11:34 am
deleted that record from the options table – running faster. Still think it could be faster, but better for now
thank you!
|
