Skip to content
Snippets Groups Projects
  1. Feb 14, 2018
  2. Feb 12, 2018
  3. Feb 09, 2018
  4. Feb 08, 2018
  5. Feb 07, 2018
  6. Feb 06, 2018
  7. Feb 05, 2018
  8. Feb 03, 2018
  9. Feb 02, 2018
  10. Feb 01, 2018
  11. Jan 31, 2018
  12. Jan 30, 2018
  13. Jan 29, 2018
  14. Jan 26, 2018
  15. Jan 25, 2018
  16. Jan 24, 2018
  17. Jan 23, 2018
    • Jan Provaznik's avatar
      Use limit for search count queries · 090ca9c3
      Jan Provaznik authored
      Search query is especially slow if a user searches a generic string
      which matches many records, in such case search can take tens of
      seconds or time out. To speed up the search query, we search only for
      first 1000 records, if there is >1000 matching records we just display
      "1000+" instead of precise total count supposing that with such amount
      the exact count is not so important for the user.
      
      Because for issues even limited search was not fast enough, 2-phase
      approach is used for issues: first we use simpler/faster query to get
      all public issues, if this exceeds the limit, we just return the limit.
      If the amount of matching results is lower than limit, we re-run more
      complex search query (which includes also confidential issues).
      Re-running the complex query should be fast enough in such case because the
      amount of matching issues is lower than limit.
      
      Because exact total_count is now limited, this patch also switches to
      to "prev/next" pagination.
      
      Related #40540
      090ca9c3
  18. Jan 22, 2018
  19. Jan 19, 2018
Loading