I want to keep the records of registered user for course registration. There are maximum 100,000 users, 1 user can registered 25 courses. Which means the maximum records can be 2,500,000. One item cannot hold more than course's details.
How can I achieve this? Should I create a separate SQL Server Database (External Data) and fetch in list using BCS?
What will be best approach.