#1854 - Support keyset pagination
-
By Chris Graham
- Added
- 2 views
| Identifier | #1854 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Support keyset pagination |
| Status | Open |
| Tags |
Type: Cross-cutting feature (custom) Type: Performance (custom) |
| Handling member | Deleted |
| Addon | core_abstract_interfaces |
| Description | Offset pagination is slow when going into deep datasets. |
| Steps to reproduce | |
| Additional information | Fuller explanation:
http://use-the-index-luke.com/no-offset |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
It's only worth doing for result sets with large numbers of records which are actively gone deep into. That could be 'news' or 'activities', but forum topics is by far the most common thing to have the issue.
#3185 would be a better approach - and maybe we could even drop what we already have of this feature if we implement that.
EDIT: No, for 2 reasons...
1) actually I was able to implement a hybrid mode, where it does a pre-query to find the keyset ID even if one wasn't provided by URL, which is massively faster than using regular MySQL LIMIT clauses. This is best of both worlds and works great.
2) a background-generated pagination is not going to work for forumview, as each new post would invalidate it (posting in a topic changes the topic order on forumview)