try:

  1. $gridConf->getComponentByType('GridFieldPaginator')->setItemsPerPage(100);

This is the original question I asked - as suggested by the commenter, I added $list = $list->limit(100); in before returning list in the modelAdmin

https://stackoverflow.com/questions/54317334/how-can-i-show-only-the-most-recent-100-results-from-the-database-in-the-cms?noredirect=1#comment95457322_54317334

Attachments:
Stack Overflow  
How can I show only the most recent 100 results from the database in the CMS?

its showing more than 100 entries when supposedly limited to 100 hah

this is grid field (sorry unrelated to the rest)

wait, is this on a gridfield, or custom frontend?