Hi everyone, Have a question regarding typical e-commerce scenario: each item may have different price in different store. suppose there are 10 million items and 1000 stores.
Option 1: use solr payloads, each document have store_prices_payload: store1|price1 store2|price2 ..... store1000|price1000 Option 2: use dynamic fields and have 1000 fields in each document, i.e. field1: store1_price: price1 field2: store2_price: price2 ... field1000: store1000_price: price1000 Option 2 doesn't look elegant, but is there any performance benchmark on solr payloads? In terms of filtering, sorting or faceting, how would query performance compare between the two? Thanks, Wei
