Feature #18631
Better search results pagination
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due 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
Associated revisions
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.
Moved search logic to Redmine::Search (#18631).
Cache search result ids for faster search pagination (#18631).
History
#1
Updated by Jean-Philippe Lang over 4 years ago
- Related to Feature #9776: Adde link(s) to first(last) page for search reult. added
#2
Updated by Jean-Philippe Lang over 4 years ago
- Related to Defect #6817: Identical creation date/time skew search results added
#3
Updated by Jean-Philippe Lang over 4 years ago
- Related to Feature #17889: Searches should be twice faster added
#4
Updated by Jean-Philippe Lang over 4 years ago
- Related to Defect #16888: Search fails for issues with identical created_on timestamp added
#5
Updated by Jean-Philippe Lang over 4 years ago
- Related to Defect #16239: Search does not return all the results added
#6
Updated by Jean-Philippe Lang over 4 years ago
- Related to deleted (Defect #16888: Search fails for issues with identical created_on timestamp)
#7
Updated by Jean-Philippe Lang over 4 years ago
- Status changed from New to Closed
- Resolution set to Fixed