... increment relation 'no_of_purchases' property when customer purchase product again?
Which approach will be better from performance perspective?
I expect it will go much faster to create new relation than update relation property value. But probably it will take longer time to get answer 'show me customers' products where they have purchased at least X same product'.
We talk about dozens of thousands of customers and 20-40 thousands of products.
What would you recommend?