Heavy query on all request

  • Resolved mdifelice

    (@mdifelice)


    4 years ago

    Version 1.9.1 included a notification for downloading the Form Vibes plugin. The way this notification is determined to be shown is not optimal first because it uses a query over all pages using a meta value LIKE comparison which, in sites with many pages, could be very resource-consuming; but also this validation is made in all pages, not only backend ones. Our main site average database CPU utilization, because of this, went from 4/6% to 20/40%.

    For now, we have commented the code that generates such query (line 437, function check_form_used inside the file inc/bootstrap.php in version 1.9.2 where the problem still persists) we want to know if you plan to address this soon.

    Possible solutions would be at least to make this call only in backend requests and, ideally, cache this query at least until a new page is saved.

    • This topic was modified 4 years ago by mdifelice.
    • This topic was modified 4 years ago by mdifelice.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Heavy query on all request’ is closed to new replies.