• Resolved trebor33

    (@trebor33)


    Hello:

    I set up the Notification plugin for my theme to handle submissions for a calendar on our website which needs to be moderated by one of our content administrators. I have used this plugin on other sites in the past and I am very happy with the functionality of the plugin.

    One potential issue I have noticed when using the Query Monitor plugin to review the server response for our site is that the Notification plugin is creating a large number of queries on every page load (close to 200). The queries are not all the same but are similar to the following:

    
    SELECT option_name, option_value
    FROM <code>wp_smx2fcb140_options</code>
    WHERE option_name IN ( '_transient_notification_comment_types', '_transient_timeout_notification_comment_types' )
    UNION SELECT 'current_time', UNIX_TIMESTAMP( NOW() ) AS option_value;
    

    The queries are being called by wp_cache_get(). These queries load on every page load on every page of our site.

    I am concerned these queries may be having a negative performance impact on our site. In testing with several speed testing tools there appears to be a significant drop in performance when the plugin is activated versus when it is deactivated.

    Is there anything I can do cut down or eliminate these queries? Could you also explain what the purpose of these queries are and why so many of them are run on each page load?

    Please get back to me when you have a chance. Thank you for your help!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Kuba Mikita

    (@kubitomakita)

    Hi!

    Yes, because of the issues with plugin loading stack we needed to introduce this caching so we can register Triggers, Carriers etc as early as possible (before Custom Post Types or Taxonomies are registered).

    We just finished a major refactoring of this and we get rid of that caching so it’s no longer instantiated. This will be released in v8.0.0 this month.

    Thread Starter trebor33

    (@trebor33)

    Hi Kuba:

    Thanks so much for your quick reply and for explaining why the caching was introduced. I will look out for the new release. Thanks again for you help, again I appreciate all of the great functionality provided by the plugin.

    -Robert

    Plugin Author Kuba Mikita

    (@kubitomakita)

    Awesome, thank you Robert!

    If you could spare a minute to write a review here I’d be very grateful ??

    Hi Kuba,

    Any update on this when we going to have performance release, I also noticed lots of queries getting fire and our DB binlog getting pileup. Site has also become slow.

    Regards
    Sandeep

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Large Number of Queries Created by Notification Plugin’ is closed to new replies.