Forums » Plugin: iQ Block Country » Logging page takes a long time to view

  • Resolved hmcnally

    (@hmcnally)


    The logging page takes a long time to view–1 minute 40 seconds to generate a report based on around <100 individual blocks or so (as far as I can tell from the report page). I’ve seen this speed issue on multiple web hosts (Dreamhost, 1and1)… yes, on shared hosting sites, but this slowness sticks out like a sore thumb compared to other front and backend MySQL-based features (security plugins, the site itself, etc.). Any ideas?

Viewing 8 replies - 1 through 8 (of 8 total)
  • I’ve had the same issue for months. Upgrading to MySQL 5.6 and PHP 7 did not fix this.

    Plugin Author Pascal

    (@iqpascal)

    Every now and then there is a report of this behavior.

    For those who report it it does not occur every time they visit the logging tab. Does it for you?

    Thread Starter hmcnally

    (@hmcnally)

    The slowness is consistent (every time the logging tab is visited).

    Consistently happens for me. What diagnostic information can I provide?

    grudesky

    (@grudesky)

    Anything we can provide to help? This is a real issue…

    Plugin Author Pascal

    (@iqpascal)

    Sorry for the late reply.

    Can you send the output on the tools tab to support . webence.nl and if possible also the number of rows in the mysql logging table.

    Plugin Author Pascal

    (@iqpascal)

    I did intensive testing on this issue but I cannot reproduce this. Even with an extremely large logging table.

    I may have found 1 culprit for this tab. On every row it tries to do a host lookup which may be slow on busy servers or servers with a slow DNS connection.

    In the new released version there is an option to “Do not lookup hosts on the logging tab”

    Thread Starter hmcnally

    (@hmcnally)

    Turning of DNS lookup appears to address this issue. Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Logging page takes a long time to view’ is closed to new replies.