Are there any limit in amount of items that can be added in a Collection?

Questions and Answers
1

Hello everyone,

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?

System Information
  • OS: Ubuntu 20.04
  • Strapi Version: 3.3.4
  • Node Version: 14.15.1
  • Database: PostgreSQL
1 Like
2

Hello, On relational databases I didn’t noticed any performance issues with 500k items. I had some of them only with mongo, since mongo isn’t a relation database.

3

Thanks @sunnyson for that info.