codeconsole commented on issue #14769:
URL: https://github.com/apache/grails-core/issues/14769#issuecomment-2957621320

   @muser83 some databases offer cursors so you can efficiently paginate 
through data without having to scan to the offset.  Using offsets is very 
inefficient for quantities of results.   
   
   You could could also simulate cursor behavior by creating an artificial 
cursor using a multi field sort+id.
   for instance, you could sort by dateCreated desc, id asc


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to