I am developing a system that records customer payments, when a customer makes a payment, the system must update the account and show the payment made and all previous payments, is here when the question is which option is best:
A. Record each payment made, this means customers have multiple records.
B. Have only one record per customer and an attribute in the database where there concatenate previous payments, so it's a string that has previous payments.
Note: The DB will have many customers that's why I'm worried about performance with this situation, especially when viewing the information on the DB.
I had never done such a system and therefore would not know how much will be affected the performance of the DB having one of these two configurations and a large number of records.
if there is a better solution is welcome