mihies wrote:
Looks interesting, however I don't think I should be very useful regarding to LLBLGenPro as you don't want to load many entities anyway. If you are loading that much entities you have problems
Even if your collection is quite small it can be useful, 10ms instead of 100ms might look like it's no big deal but if you have to repeat the searching process 200-4000 times, it's a huge gain.
We had to provide in-memory editing of very big orders (many thousands products) in our application. When editing an order, End-users don't add products one at a time, they use custom tools and formulas to select large ranges of products. For each product in the selection we have to check if it already exists in the order with the specified size and color attributes, in case it's already there, we increase the quantity, in case it's not there, we add it.
Doing so without indexing is just too inefficient.