Am in the process of designing a database to a rather large project and well need some feedback from the 'experts' of what way to go.
I have a project with 154 million users that each have something in the area of 9,000 records stored each year.
Option 1: Create a table for each user with the users unique ID, to store their respective data into. Downside is that I then will have a database with more than 154 million tables.
Option 2: Store all data in a single table and then create a column that hold each users unique ID in, when it is needed to retrieve their data. Downside is that more than 1.3 billion rows are added into a single table each year, making it impossible large.
Well simply looking for pro/cons or other thoughts on how to design this, before I am starting out. Am currently leaning towards Option 1 although it do give me some other challenges in matters of viewing the whole DB etc.