You will definitely be pushing the limits for reasonable performance. Maybe
4-5 years from now you will be able to get decent performance with hundreds
of fields and dozens of faceted fields, but I'd be surprised if you could
get decent performance with more than about 100 fields and a dozen facets.
The length of a field name should not be a problem for queries other than
readability. Just be sure to stick with Java-style names (alpha, digit,
underscore).
The bottom line: Do a proof of concept (POC) first - and tell us how it
performs.
-- Jack Krupansky
-----Original Message-----
From: kobe.free.wo...@gmail.com
Sent: Thursday, March 21, 2013 2:56 AM
To: solr-user@lucene.apache.org
Subject: SOLR - Documents with large number of fields ~ 450
Hello All,
Scenario:
My data model consist of approx. 450 fields with different types of data. We
want to include each field for indexing as a result it will create a single
SOLR document with *450 fields*. The total of number of records in the data
set is *755K*. We will be using the features like faceting and sorting on
approx. 50 fields.
We are planning to use SOLR 4.1. Following is the hardware configuration of
the web server that we plan to install SOLR on:-
CPU: 2 x Dual Core (4 cores) | RAM: 12GB | Storage: 212 GB
Questions :
1)What's the best approach when dealing with documents with large number of
fields. What's the drawback of having a single document with a very large
number of fields. Does SOLR support documents with large number of fields as
in my case?
2)Will there be any performance issue if i define all of the 450 fields for
indexing? Also if faceting is done on 50 fields with document having large
number of fields and huge number of records?
3)The name of the fields in the data set are quiet lengthy around 60
characters. Will it be a problem defining fields with such a huge name in
the schema file? Is there any best practice to be followed related to naming
convention? Will big field names create problem during querying?
Thanks!
--
View this message in context:
http://lucene.472066.n3.nabble.com/SOLR-Documents-with-large-number-of-fields-450-tp4049633.html
Sent from the Solr - User mailing list archive at Nabble.com.
