Duplicate Queries

  • Resolved UmbrellaWeb

    (@umbrellaweb)


    2 years, 4 months ago

    Hello,

    So spotted this on the front end hghlighted by query monitor:

    SHOW TABLES LIKE 'dm_snippets'	2	

2 calls
	Plugin: code-snippets
2 calls
	Code_Snippets\execute_active_snippets()
1 call
Code_Snippets\Active_Snippets->init()
1 call

    Is that duplication really required?

    • This topic was modified 2 years, 4 months ago by UmbrellaWeb. Reason: edited for privacy
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Shea Bunge

    (@bungeshea)

    This is a good point. It’s occurring because the tables are fetched from twice, once for the content snippets, and once for the PHP snippets. I’ll see what I can do to optimise this further.

    Thread Starter UmbrellaWeb

    (@umbrellaweb)

    @bungeshea thank you for the update.

    That would be great to squeeze some additional performance out of your plugin ??

    Plugin Author Shea Bunge

    (@bungeshea)

    If you are looking for performance, I’d recommend using object caching. The results of these queries are cached meaning that they aren’t run at all on most page loads.

    Thread Starter UmbrellaWeb

    (@umbrellaweb)

    @bungeshea yes, we are using it for some site i.e those that have it enabled on the web host.

    However many (client sites) dont use great hosting so its an uphill battle to get the sites optimised hence why we look at everything possible to squeeze that extra little bit of performance out…

    Ideally getting sites to better hosting fixes (or at the very least improves the performance) but getting clients to do this can sometimes prove to be an uphill battle… if you get what I mean…

    Plugin Author Shea Bunge

    (@bungeshea)

    Thank you once again for reporting this @umbrellaweb. I’ve created a fix to prevent this from happening. It’ll be included in the next plugin release.

    Thread Starter UmbrellaWeb

    (@umbrellaweb)

    @bungeshea thanks. look forward to the upadte ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Duplicate Queries’ is closed to new replies.