Improve performance for larger numbers of events

[UdaraJay]

Improve performance of UI and API when displaying >10K events. Working with 24 hours to 7 days of data will work fine for most small–medium collections of events, but it would be neat to be able to support larger number of events for the sake of browsing historical data across larger timespans.

Possible improvements:

• Summary API endpoints that returns data that's been pre-summarized. Ideally, weekly/monthly/yearly data should be summarized on a schedule so we don't need to process large numbers of events on the fly.
• Chunking or pagination when handling larger numbers of events.

[eznix86]

Create a mysql view : https://www.prisma.io/docs/concepts/components/prisma-schema/views
Then use vercel cron to update the views: https://vercel.com/guides/how-to-setup-cron-jobs-on-vercel