multiple database requests for keyExpDays

  • Resolved jp1977

    (@jp1977)


    9 months, 3 weeks ago

    Our hosting service has reported that our site is making multiple requests for the following and has restricted the site because of this:

    SELECT name, val, autoload FROM wp_wfconfig WHERE name = 'keyExpDays'

    this query returns no results, should it?

    I have checked and a key has been added for WF

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfpeter

    (@wfpeter)

    9 months, 3 weeks ago

    Hi @jp1977, thanks for getting in touch.

    We are always working to ensure the plugin runs as efficiently as possible, especially during a high rate of activity (such as a scan). Most of our values are autoloaded in a single query, but if a value doesn’t exist, it can cause a separate query like the one shown above.

    It seems unusual for a host to pick out that query as a problem though. If your host can provide any other details about why this was a significant problem, it would be helpful. I could speculate that your site had a huge traffic spike, but would expect this to be one of many queries from Wordfence and other plugins during a time like that.

    Many thanks,
    Peter.

    Plugin Support wfpeter

    (@wfpeter)

    9 months, 2 weeks ago

    Hi @jp1977,

    Did you hear any more from your host about the logs that led them to this conclusion? It would help us to identify if there are instances when this (or similar) queries could be cut down.

    Thanks again,
    Peter.

    Plugin Support wfpeter

    (@wfpeter)

    9 months, 1 week ago

    We have scheduled an update to avoid extra keyExpDays queries in an upcoming plugin release.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘multiple database requests for keyExpDays’ is closed to new replies.