Details

    • Type: Sub-task
    • Status: Unverified Fix
    • 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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: