Return to previous page

Theme optimizations - by jrevillini - on WordPress WooCommerce support

This topic has 12 replies, 5 voices, and was last updated 7 years, 10 months ago ago by Eva Kemp

jrevillini

Member

September 6, 2015 at 13:57

I’m noticing some things the theme is doing which may be able to be optimized. These are kind of picky, but on an active site with an advanced woocommerce system, anything that can be optimized comes into question. I’m using the plugin Debug Objects to do this research.

file: /wp-content/themes/woopress/framework/theme-functions.php
1. line 608
1.0ms (0.000967025756836s)
UPDATE wp_options SET option_value = ‘1’ WHERE option_name = ‘sc_chat_validate_license’

I don’t have the Screets Chat plugin activated, yet the plugin runs this on every admin page load. I suggest only running this on activation.

2. line 3067 & 3044
0.2ms (0.000231981277466s)
SELECT option_value FROM wp_options WHERE option_name = ‘etheme_custom_sidebars’ LIMIT 1

Seems normal but gets run twice on every admin page load

file: wp-content/themes/woopress/framework/inc/taxonomy-metadata.php
3. line 57 & 34
0.4ms (0.00043511390686s)
show tables like ‘wp_taxonomymeta’

Not really sure why this would be run twice or at all, but it gets run every admin page load

file: wp-content/themes/woopress/option-tree/includes/ot-cleanup-api.php
4. line 69
0.3ms (0.000349044799805s)
SELECT * FROM wp_posts WHERE post_type = ‘option-tree’ LIMIT 2

AND

line 70
0.3ms (0.00032901763916s)
SHOW TABLES LIKE ‘wp_option_tree’

The cleanup doesn’t really need to run every admin page load, does it? Maybe just trigger the check on option-related pages, then do a check once per hour if it’s really necessary to monitor.

#84886 Copied

11 Answers

Brian Johnson

Member

October 7, 2015 at 15:55

Hello

Thank you for showing the way to optimize theme. It is very likely we will take your hints in consideration for future releases. If you have any questions be free to contact us.

Regards,
Brian johnson

#92277 Copied

webdesignit

Participant

December 23, 2016 at 02:01

Has the above been looked at ? I’m currently in the process of optimizing my site and noticing the sc_chat_validate_license constantly appearing – often taking up to 0.4s .. and screets isn’t even installed on my legenda site! this seems like very poor optimization, especially since you guys have known about this issue.

How do I resolve this ?

Thanks

#149978 Copied Theme version: legenda 3.0.3 WooCommerce version: 2.6.11

Jack Richardson

Support staff

December 23, 2016 at 11:32

Hello @webdesignit,

Due to GTmetrix results https://gtmetrix.com/reports/bcdirect.co.nz/t1be9cos you need follow their suggestions to increase site loading speed.
These articles should help you:
http://www.laplacef.com/2014/05/24/how-to-defer-parsing-javascript-in-wordpress/
http://www.elegantthemes.com/blog/tips-tricks/optimize-images-for-your-wordpress-website
https://www.mvestormedia.com/leverage-browser-caching-w3-total-cache/
http://technumero.com/internet/how-to-leverage-browser-caching-wordpress/3213

Best regards,
Jack Richardson.

#150005 Copied

webdesignit

Participant

December 25, 2016 at 05:29

Caching was all off because I was doing testing… If you look now its as it was..

Back to the original issue though.. Is there a fix?- how can I stop the screets license from being queried in sql repeatedly when its not even installed?

Kind Regards,
Tom

#150116 Copied

Eva Kemp

Support staff

December 26, 2016 at 17:38

Hello,

Could you please show a screenshot where you see the notice regarding sc_chat_validate_license?

Regards,
Eva Kemp.

#150224 Copied

webdesignit

Participant

December 27, 2016 at 05:43

https://s23.postimg.org/rrhmqpzqz/screets.jpg

This shows up in Query Monitor under slow queries on pretty much every page(front&backend).. sometimes other queries show up depending on whats rendering, but this one is always there – the time it takes changes alot from 0.01 > 0.9.

Since I’m trying to optimize as much as possible I’d really just like a way to prevent this query on every page – Can I perhaps remove some lines from the files indicated in the OP ? or a snippet to prevent it from running maybe ?

Kind Regards and Merry Christmas!
Tom

#150255 Copied

Eva Kemp

Support staff

December 27, 2016 at 16:50

Hello,

Do you mean you see that notice in your database?
Could you please show full screenshot to have clear understanding?

Regards,
Eva Kemp.

#150326 Copied

webdesignit

Participant

January 1, 2017 at 23:57

Happy new year, hope everyone has a great start to it 🙂

Ah no the message is in Query Monitor, which reports on SQL queries being actioned by wordpress.. below are 2 screenshots showing the plugin operating within the context of the site.

The page loads.. queries are reported on up top- accessed by the dropdown menu
https://i.imgsafe.org/9885fc8448.jpg

Can then click and see details on queries
https://i.imgsafe.org/9885ede1a4.jpg

#150668 Copied

Eva Kemp

Support staff

January 3, 2017 at 17:08

Hello,

Please check if the problem persists with default WordPress theme.
Let us know the result.

Regards,
Eva Kemp.

#150776 Copied

webdesignit

Participant

January 3, 2017 at 22:08

Hey,

Tested – using twenty seventeen theme the sc_chat_validate_license query does not show up.

Cheers,
Tom

#150793 Copied

Eva Kemp

Support staff

January 5, 2017 at 16:09

Hello,

We’ve forwarded this issue to our developers and it should be fixed in one of the theme updates.
Please take our apologies for inconveniences.

Regards,
Eva Kemp.

#150954 Copied
Viewing 12 results - 1 through 12 (of 12 total)