• Resolved Sjourney

    (@sjourney)


    v1.5.2
    The following SQL queries are executed each time a page is loaded on the site. No matter if the page has anything to do with PD or not.

    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name  ORDER BY
    g.order, v.order;
    0.0839 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name AND
    v.form_element IN ("text-line","hidden") ORDER BY g.order, v.order;
    0.0770 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name AND
    v.form_element IN ("text-line","hidden") ORDER BY g.order, v.order;
    0.0780 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name AND
    v.form_element IN ("text-line","hidden") ORDER BY g.order, v.order;
    0.0911 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name  ORDER BY
    g.order, v.order;
    0.0808 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name WHERE
    v.sortable = 1  ORDER BY g.order, v.order;
    0.0751 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name WHERE
    v.sortable = 1  ORDER BY g.order, v.order;
    0.0720 [ms]
    SELECT v.*, g.order FROM wordpress_participants_database_fields v INNER JOIN wordpress_participants_database_groups g ON v.group = g.name AND
    v.form_element IN ("text-line","hidden") ORDER BY g.order, v.order;

    Is there a way to tweak this so that the queries are executed solely in relevant pages/posts?

    http://wordpress.org/plugins/participants-database/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘PD executes SQL sitewide. How to limit that to certain pages?’ is closed to new replies.