I have designed a database and came to the point of actually deciding which storage engine is better for my case.
I estimate that during the first few years I would have around 100,000 - 500,000 users. Some of the users can also have multiple posts, comments, etc. The number of users can go up to maybe a max of 10,000,000. Well I am just estimating.
I am planning to use a BIGINT for my
user_id or in a certain situation I may have to go for a different route where I would store a user_id as a string like '000123456789'. I am not really decided about that.
My CRUD operation estimates are like this:
So my focus is on Read and the Update.