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

          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: