Slow queries

  • Resolved yk11

    (@yk11)


    9 years, 2 months ago

    I installed query-monitor db queries debugging plugin to resolve a plugin issue unrelated to Wordfence.

    The tool highlighted a slow query by Wordfence: SHOW FULL COLUMNS
    FROM wp_wfLockedOut. The results are 5 rows returned in 0.1872 seconds.

    This only happens when the page is not cached.

    Is this expected?

    https://www.ads-software.com/plugins/wordfence/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WFMattR

    (@wfmattr)

    Thanks for the report. I don’t think this used to happen, and I have submitted a bug report to our dev team, with reference number FB1293.

    It looks like the queries are caused by wp-db.php, and are probably due to the format of the content in these fields, causing extra checking that should not be necessary.

    -Matt R

    Hello @wfmattr,

    I’m having exactly the same problem as @yk11 — the exact same slow query on the wfLockedOut table that returns 5 results after 0.2092 seconds.

    I tried searching for the bug report ref. FB1293 but couldn’t find it anywhere. Has this issue been resolved?

    Thanks

    Hello everybody following this thread.
    I have the same problem. Just wanted to add some details about the function that is supposed to generate the query:

    wfDB->querySingle()
 wp-content/plugins/wordfence/lib/wfDB.php:10

    as stated by Query Monitor.
    In my case the query time spans from 0.1800 and 0.2500 secs.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Slow queries’ is closed to new replies.