Potential issues with a type that will have 500k entries per year?

A bit of context. The site is meant for an Arena that host events. That part, no issues.

We want to start adding a “My account” page that will list the events you bought as a client. We gather that information from a well-know ticket seller (no name, no shame :D).
So I will import the new tickets every couple hours. The volume should be around 400,000 to 500,000 a year. Each ticket will have a relationship to the user and to the event.

Should I expect issues with how Strapi would handle this? Queries will always be scoped per client bringing back 1 to 5 results. The admins won’t have any reason to “Content Manage” this.

Obviously I will size my postgres instance adequatly.

Any feedback would be very welcomed!

This topic has been created from a Discord post (1291491517550034976) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

Note: I may keep 3 to 4 years but then purge if needed old ones.