Slow database query and performance

  • Resolved pirulee

    (@pirulee)


    4 years, 3 months ago

    I have the “Query Monitor” plugin activated in many instances where Ninja Forms is also installed.

    I constantly get informed that the plugin runs the following update on every page load (at the admin dashboard), which is also identified as the slowest on every site (due to the purpose of the table):

    
UPDATE wp_options
SET option_value = '0'
WHERE option_name = 'ninja_forms_needs_updates'

    As a plugin developer myself I know that, to keep good performance, every update check should not be handled on every page load, it should be handled using WordPress updater hooks which runs over *wp-cron* only twice a day.

    Consider migrating and refactoring this on later versions to keep consistency with WordPress updates (update transient) and improve performance, you can take a look at this gist example:
    https://gist.github.com/danielbachhuber/7684646

    Regards

    • This topic was modified 4 years, 3 months ago by pirulee.
  • The topic ‘Slow database query and performance’ is closed to new replies.