Feature #18631

Better search results pagination

Added by Jean-Philippe Lang about 3 years ago. Updated about 3 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Search engine
Target version:3.0.0
Resolution:Fixed

Description

Current pagination is based on results timestamps which leads to several problems. The most important being that some results with same timestamps may not be displayed.


Related issues

Related to Redmine - Feature #9776: Adde link(s) to first(last) page for search reult. New
Related to Redmine - Defect #6817: Identical creation date/time skew search results New 2010-11-03
Related to Redmine - Feature #17889: Searches should be twice faster New
Related to Redmine - Defect #16239: Search does not return all the results Closed

Associated revisions

Revision 13739
Added by Jean-Philippe Lang about 3 years ago

Rewrites search engine to properly paginate results (#18631).

Instead of counting and retrieving results based on their timestamps, we now load all result ids then load the appropriate results by their ids. This also brings a 2x performance improvement as we search tokens in one of the 2 queries only.

Revision 13769
Added by Jean-Philippe Lang about 3 years ago

Moved search logic to Redmine::Search (#18631).

Revision 13770
Added by Jean-Philippe Lang about 3 years ago

Cache search result ids for faster search pagination (#18631).

History

#1 Updated by Jean-Philippe Lang about 3 years ago

  • Related to Feature #9776: Adde link(s) to first(last) page for search reult. added

#2 Updated by Jean-Philippe Lang about 3 years ago

  • Related to Defect #6817: Identical creation date/time skew search results added

#3 Updated by Jean-Philippe Lang about 3 years ago

#4 Updated by Jean-Philippe Lang about 3 years ago

  • Related to Defect #16888: Search fails for issues with identical created_on timestamp added

#5 Updated by Jean-Philippe Lang about 3 years ago

  • Related to Defect #16239: Search does not return all the results added

#6 Updated by Jean-Philippe Lang about 3 years ago

  • Related to deleted (Defect #16888: Search fails for issues with identical created_on timestamp)

#7 Updated by Jean-Philippe Lang about 3 years ago

  • Status changed from New to Closed
  • Resolution set to Fixed

Also available in: Atom PDF