I am trying to store UserActivity of types: Search, Page Visit, Login, Logout, Likes, Rate, Subscribe, Notification Sent, Follower Added, Following, Add Item to List, etc.
I am assuming I might end up having lots of items for every single activity that a single user performs.
Now when I think of this, I will end up having millions of rows pretty soon with 10K users.
Since I am using PostgreSQL for Strapi, I am a bit positive that it should be able to work with this easily. Obviously, this data would be pulled on a per-user basis and not everything in one short.
Do we know if there are any limitations on the number of items a Collection can have?
Or are there any known performance implications that this might create?
- OS: Ubuntu 20.04
- Strapi Version: 3.3.4
- Node Version: 14.15.1
- Database: PostgreSQL