I have a table like this.
investment_id | investor_id | deposit | Date | Status
I will be depositing funds into this table. For eg. If I am paying out 1000 investors at a time, 1000 rows will be added to this table. I might do this 100 times a day. That's 100,000 rows added in a day. Each deposit I do will be unique, even though it might be going to the same person multiple times.
This could end up with million of rows. I am wondering if this is the correct way to do this or is there a better method?