Display Record List with huge data in Tempo

Hi all,

For context, I'm trying to display a record type "Files" which as of last week has hit the memory threshold (800,000+ records).

The record type is still legacy.

When I try to access the record via Tempo > Records > Files,

I'm displayed with 

"The Requested Record Type Is Not Available An error occurred while retrieving the data for "File". Details: Unexpected error executing query ...."

I've tried a few approaches but the most noteworthy one is  : 

1) Updating the default filter criteria to only show Files that were created the last 2 years. The problem with this is if I need to access something older than the 2 years I won't be able to.

In short,

I just want to limit the Record List view to maybe 200 records but the data source having access to all 800,000+ records so that I can still have a functioning record that can display the appropriate views when accessed individually.

Thank you.