Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-12891

Long page generation time when banlist is long

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.1.0-RC3
    • 3.1.0-RC2
    • None
    • PHP 5.5.9, MySQL 5.6.16, XAMPP 3.2.1

      In 3.0 when the banlist table had many rows the pages which displays the banlist was still generated very fast.
      However in 3.1 the pages are generated very very slow.
      For example:
      3.0 - 24219 rows

      Page generated in 1.2381 seconds with 4 queries + 2 queries returning data from cache
       
      Time spent on mysqli queries: 0.19001s | Time spent on PHP: 1.04806s

      3.1 - 5770 rows

      Page generated in 11.0586 seconds with 5 queries + 1 query returning data from cache
       
      Time spent on mysqli queries: 0.076s | Time spent on PHP: 10.98263s

      Although the 3.1 board has way less rows it tooks about 10x longer.

      Originally mentioned here: https://www.phpbb.de/community/viewtopic.php?f=33&t=231868 (german)

            nickvergessen Joas Schilling
            Elsensee Oliver Schramm [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: