Is NAME a product name? Why would it be multivalue? And why would it appear
on more than one document? Is each 'document' a package of products? And
the pricing tiers are on the package, not individual pieces?
So sounds like you could, potentially, have a PriceListX column for each
user. As your User base grows, the number of columns you need may grow (you
already bumped up from 2000 to 5000 in the space of a couple posts :) ). Is
that right?
How many products (or packages of products) do you have? Could you flip this
on its ear and make a User the document. Then it could have just 3
multivalue fields (beyond any you need to identify the user like user_id)
product_id
product_name
product_price
Downside is if a new product is introduced you have to re-index all users
that have a price point on that product.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Indexing-Question-for-large-dataset-tp2816344p2816994.html
Sent from the Solr - User mailing list archive at Nabble.com.
