1854: Support keyset pagination - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

1854	Composr	core_abstract_interfaces	public	2015-04-09 13:54	2019-11-24 21:19

Reporter	Chris Graham	Assigned To	Guest
Priority	normal	Severity	feature
Status	new	Resolution	open

Summary	1854: Support keyset pagination
Description	Offset pagination is slow when going into deep datasets.
Additional Information	Fuller explanation: http://use-the-index-luke.com/no-offset
Tags	Type: Cross-cutting feature , Type: Performance
Attach Tags	(Separate by ",")

Time estimation (hours)	50
Sponsorship open

Date Added	Member	Amount Sponsored

Chris Graham 2015-07-18 10:07 administrator ~2960	See also 'search keys' In Tapatalk implementation.

Chris Graham 2016-06-22 23:38 administrator ~4064	This is now implemented for forum topics (not in Tapatalk though). 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.

Chris Graham 2019-11-18 21:20 administrator ~6160 Last edited: 2019-11-24 21:19	One problem with this is pagination becomes less user-friendly. IIRC we have to disable the 'last' button when using keyset pagination. 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)

View Status	Private (for security issues or disclosing of private information; if you submit as a guest, you will not be able to see your submission)
Note
Upload Files Maximum size: 32,768 KiB	Attach files by dragging & dropping, selecting or pasting them.
You are not logged in	You are not logged in. This means you will not get any e-mail notifications. And if you reply, we will not know for sure you are the original poster of the issue.

Date Modified	Username	Field	Change
2016-06-20 03:14	Chris Graham	Tag Attached: Type: Performance
2016-06-22 23:38	Chris Graham	Note Added: 0004064
2016-12-08 16:19	Chris Graham	Tag Attached: Type: Cross-cutting feature
2017-04-05 12:04	Chris Graham	Relationship added	related to 3185
2017-05-01 16:48	Chris Graham	Category	core => core_abstract_interfaces
2019-11-18 21:20	Chris Graham	Note Added: 0006160
2019-11-24 21:15	Chris Graham	Note Edited: 0006160
2019-11-24 21:19	Chris Graham	Note Edited: 0006160