Resources list view performance degrades after 1 million objects

[donrestarone]

trafficstars

Describe the bug

When a API Resource list in an API Namespace exceeds 1 million Resources,

1. The table view becomes slow ( 9 second response time)
2. Navigating through the Pagination becomes slow ( 9 second response time)

possible culprits:

1. over-fetching data
2. slow query