I have a “provider” custom post. I would like to save the invoices received from each provider (not the actual invoice file, just a few data : invoice number, date, amount.)
I have 2 choices :
– Either I create a repeater in the provider custom post type.
– Either I create an “invoice” custom post type with these few custom fields + a relationship field to assign each of them to the corresponding provider.
I tend to prefer the first option because it seems lighter (i don’t really want to create a custom post type specifically to save a few fields) but I also read somewhere that ACF repeaters are not made to have hundreds of rows (which some providers will have eventually after a few years).
Which solution makes more sense from a database/performance point of view?