Currently I have a single list where I store some data for all users. The problem is that the list has scalability issues after 5000 rows. I was thinking to create a list for each user.
How many lists can I create in Sharepoint 2010 ? Is there a limit? I need to create at least 1 million lists.
What is the recommended approach ?