I'm paginating to 25 items a large table (>5k items) and the performance it's terrible. 5 seconds on my localhost with opcache enabled.
Memory is also really high. I've tried to override the getTableQuery function in the List resource file to select only the fields I'm showing in the table, but has no effect on the memory used.
What can I do to improve this?