• Resolved codi0

    (@codi0)


    I think Forminator is a very good plugin. One thing I wanted to give some feedback on is I’ve noticed it can produce some unnecessary DB queries.

    This is an example from the home page of a site in development, where the user is signed out. I assume its down to options that are never set, but are checked for on every page. It should be relatively easy to stop that from happening?

    SELECT option_value FROM wp_options WHERE option_name = 'forminator_activated_addons' LIMIT 1 | 0.00063
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_stripe_configuration' LIMIT 1 | 0.00071
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_module_enable_load_ajax' LIMIT 1 | 0.00056
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_module_use_donotcachepage' LIMIT 1 | 0.00049
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_trello_settings' LIMIT 1 | 0.00050
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_mailjet_settings' LIMIT 1 | 0.00041
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_googlesheet_settings' LIMIT 1 | 0.00054
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_webhook_settings' LIMIT 1 | 0.00050
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_slack_settings' LIMIT 1 | 0.00059
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_hubspot_settings' LIMIT 1 | 0.00055
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_activecampaign_settings' LIMIT 1 | 0.00055
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_campaignmonitor_settings' LIMIT 1 | 0.00113
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_mailchimp_settings' LIMIT 1 | 0.00051
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_addon_aweber_settings' LIMIT 1 | 0.00039
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_paypal_configuration' LIMIT 1 | 0.00066
    SELECT option_value FROM wp_options WHERE option_name = 'forminator_permissions' LIMIT 1 | 0.00098

    There are also a number of action scheduler queries occurring for forminator data on every page load.

    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_general_data_protection_cleanup' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00089
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_general_data_protection_cleanup' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00057
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_general_data_protection_cleanup' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00064
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_daily_cron' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00056
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_send_export' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00068
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_process_report' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00057
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='forminator_action_scheduler_cleanup' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1 | 0.00064

    • This topic was modified 11 months, 2 weeks ago by codi0.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Needless wp_options queries’ is closed to new replies.