Improve sql and queries

  • Resolved Rookie

    (@alriksson)


    4 years, 8 months ago

    43	SELECT *
FROM <code>wp_fluentform_forms</code>
WHERE <code>id</code> = '1'
LIMIT 1	+
WpFluent\Q\QueryBuilderHandler->get()
Plugin: fluentform	1	0.0053

    A slow SQL query that runs on all wp-admin pages. Is it really necessary to run once the form isn’t used?

    Please consider improving this and remove loading queries in wp-admin if the block or shortcode isn’t used. As in my case I only need it on one page I don’t want the plugin to run SQL queries everywhere slowing down wp-admin.

    Above is mentioned the slow one, but wp fluentform runs several which is fast, but no reason to load. The fewer queries, in general, the better.

    WP Fluent form also loads several css and js even if the form isn’t present.

    • This topic was modified 4 years, 8 months ago by Rookie.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Shahjahan Jewel

    (@techjewel)

    Hello @alriksson
    Thanks for reporting this. I will check it improve it. By the way, We don’t load any CSS/JS in the frontend if your form is not available in your page/post.
    Again, I will recheck again and improve if possible.

    Thread Starter Rookie

    (@alriksson)

    >Thanks for reporting this. I will check it improve it.

    thanks please let me know once improved and ticket is closed.

    >We don’t load any CSS/JS in the frontend if your form is not available in your page/post.

    No, but backend in wp-admin you load several ?? Some that even isn’t minified.
    Total footprint from assets: 16.6KB where 8.9kb is javascript. When it’s not needed. Thanks Shahjahan ??

    Javascripts:
    /wp-content/plugins/fluentform/public/js/form-submission.js?ver=3.5.2
    /wp-content/plugins/fluentform/public/js/fluent_gutenblock.js?ver=5.4

    Stylesheets:
    /wp-content/plugins/fluentform/public/css/fluent_gutenblock.css?ver=5.4
    wp-content/plugins/fluentform/public/css/fluentform-public-default.css?ver=3.5.2
    /wp-content/plugins/fluentform/public/libs/selectWoo/select2.css?ver=5.4
    /wp-content/plugins/fluentform/public/css/fluent-forms-public.css?ver=3.5.2

    Plugin Author Shahjahan Jewel

    (@techjewel)

    Hello @alriksson,
    Thanks for the info and appreciate it. I will check it and improve in our next version for sure. I already added this in our internal dev backlog and made it as a priority.

    Thread Starter Rookie

    (@alriksson)

    Many thanks for the fast response and action.

    Happy to hear! You are welcome!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Improve sql and queries’ is closed to new replies.