I design a system in which a user can enter a budget and a query returns him sets of objects that he can afford from different vendors. The system has hundreds of different types of combinations (i.e. [Knife, Spoon, Fork], [Spoon, Glass, Mug]) so that the request is directed (using the nosql database).
The query will look at the different types of combinations and will compare prices to get the full set from different vendors, then eliminate any combination of suppliers exceeding the budget. I'm trying to do it effectively because there are hundreds (thousands possible in the future) of different types of combination and more than 4 suppliers, that might be expensive. in calculation.
My question is: are there any solutions to reduce computing costs by using standard query building techniques?