I have a table which consists of around 2500 rows for a single user id. And for each user id, same number of rows will be there. If number of users increase then I am afraid number of rows will be vast.
So can you please suggest me what to do ? Should I use different tables for different users or a single table for all users. And another thing , is there any limitation of how many maximum number rows/columns can be there in a single table ?
My database looks like below structure :
for User1
id ---- col1
1 ---- value1
2 ---- value2
..............
2500 ---- value 2500
for User2
id ---- col1 ...
1 ---- value1
2 ---- value2
..............
2500 ---- value 2500
likewise it will continue for suppose 1 million users
So, should I go for creating separate tables for each users or should I create 1 table containing all the records.