How to work with the visits API on Connect when your APIs have millions of visits

The current visits API endpoint for Posit Connect returns 500 visits at a time. API endpoints can often be hit 10's of thousands of times a day, with at least one of our APIs occuring more than 1 million visits.

This makes it mostly impractical to use our visits data.

Is there a better way to access to data? I'd like to know how use of the API has evolved over time for our main APIs.