Hi,
I have a ~ 20 mil products database, split in multiple arborescent categories, each with it's own discount percentage.
If I load all the products, categories and percentages the classic way I end up with a 2 mld row table which is unusable due to it's size.
Is it possible to load the discounts after selecting the required categories? (in a server app, not desktop)
Thank you.