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

    • Type: Sub-task
    • Status: Unverified Fix (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.6, 3.0.7, 3.0.7-PL1
    • Fix Version/s: 3.0.8-RC1
    • Component/s: Search
    • Labels:
      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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-9636 Search for unread posts uses message_body template instead of search_results template when there's no unread posts to display.

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

            Activity

              People

              • Assignee:
                rxu rxu
                Reporter:
                rxu rxu
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: