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.

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development