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

Drop redundant SQL query for unreads fetching

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.0.8-RC1
    • 3.0.6, 3.0.7, 3.0.7-PL1
    • Search
    • None

      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.

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

              Created:
              Updated:
              Resolved: