Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-16280

Poor inefficient SQL on reading the notifications table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.2.8
    • None
    • None
    • None

    Description

      In phpbb/notification/method folder there is the Board.php file.

      There is a public function in it called get_notified_users that reads the Notifications table.

      If the site admin chooses to not have Notifications removed from their forum, then the Notifications table will constantly increase. 

      The SQL in this public function appears to be inefficient as the Notifications table doesn't include the column 'item_parent_id' as an index. Its possible that other columns may need to be indexed.

      Attachments

        Activity

          People

            Unassigned Unassigned
            chanlon1 chanlon1 [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: