Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8779 Slow search for 'View unread posts'
  3. PHPBB3-9606

Drop redundant SQL query for unreads fetching

    XMLWordPrintable

Details

    • Sub-task
    • Status: Unverified Fix (View Workflow)
    • Minor
    • Resolution: Fixed
    • 3.0.6, 3.0.7, 3.0.7-PL1
    • 3.0.8-RC1
    • Search
    • None

    Description

      Currently we have redundant SQL query in search.php in order to carry out search for unread posts:

      				if (!empty($unread_list))
      				{
      					$sql = 'SELECT t.topic_id
      						FROM ' . TOPICS_TABLE . ' t
      						WHERE ' . $db->sql_in_set('t.topic_id', array_keys($unread_list)) . "
      						$sql_sort";
      					$field = 'topic_id';
      				}
      

      It should be dropped to speedup the things.

      Attachments

        Issue Links

          Activity

            People

              rxu rxu
              rxu rxu
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: