I would reconsider the strategy of mashing so many different record types into one Solr collection. Sure, you get some advantage from denormalizing data, but if the downside cost gets too high, it may not make so much sense.
I'd consider a collection per record type, or at least group similar record types, and then query as many collections - in parallel - as needed for a given user. That should also assure that a query for a given record type should be much faster as well. Surely you should be able to examine the query in the app and determine what record types it might apply to. When in doubt, make your schema as clean and simple as possible. Simplicity over complexity. -- Jack Krupansky On Thu, May 28, 2015 at 12:06 PM, Erick Erickson <erickerick...@gmail.com> wrote: > Gotta agree with Jack here. This is an insane number of fields, query > performance on any significant corpus will be "fraught" etc. The very > first thing I'd look at is having that many fields. You have 3,500 > different fields! Whatever the motivation for having that many fields > is the place I'd start..... > > Best, > Erick > > On Thu, May 28, 2015 at 5:50 AM, Jack Krupansky > <jack.krupan...@gmail.com> wrote: > > This does not even pass a basic smell test for reasonability of matching > > the capabilities of Solr and the needs of your application. I'd like to > > hear from others, but I personally would be -1 on this approach to > misusing > > qf. I'd simply say that you need to go back to the drawing board, and > that > > your primary focus should be on working with your application product > > manager to revise your application requirements to more closely match the > > capabilities of Solr. > > > > To put it simply, if you have more than a dozen fields in qf, you're > > probably doing something wrong. In this case horribly wrong. > > > > Focus on designing your app to exploit the capabilities of Solr, not to > > misuse them. > > > > In short, to answer the original question, more than a couple dozen > fields > > in qf is indeed too many. More than a dozen raises a yellow flag for me. > > > > > > -- Jack Krupansky > > > > On Thu, May 28, 2015 at 8:13 AM, Steven White <swhite4...@gmail.com> > wrote: > > > >> Hi Charles, > >> > >> That is what I have done. At the moment, I have 22 request handlers, > some > >> have 3490 field items in "qf" (that's the most and the qf line spans > over > >> 95,000 characters in solrconfig.xml file) and the least one has 1341 > >> fields. I'm working on seeing if I can use copyField to copy the data > of > >> that view's field into a single pseudo-view-field and use that pseudo > field > >> for "qf" of that view's request handler. The I still have outstanding > with > >> using copyField in this way is that it could lead to a complete > re-indexing > >> of all the data in that view when a field is adding / removing from that > >> view. > >> > >> Thanks > >> > >> Steve > >> > >> On Wed, May 27, 2015 at 6:02 PM, Reitzel, Charles < > >> charles.reit...@tiaa-cref.org> wrote: > >> > >> > One request handler per view? > >> > > >> > I think if you are able to make the actual view in use for the current > >> > request a single value (vs. all views that the user could use over > time), > >> > it would keep the qf list down to a manageable size (e.g. specified > >> within > >> > the request handler XML). Not sure if this is feasible for you, > but it > >> > seems like a reasonable approach given the use case you describe. > >> > > >> > Just a thought ... > >> > > >> > -----Original Message----- > >> > From: Steven White [mailto:swhite4...@gmail.com] > >> > Sent: Tuesday, May 26, 2015 4:48 PM > >> > To: solr-user@lucene.apache.org > >> > Subject: Re: When is too many fields in "qf" is too many? > >> > > >> > Thanks Doug. I might have to take you on the hangout offer. Let me > >> > refine the requirement further and if I still see the need, I will let > >> you > >> > know. > >> > > >> > Steve > >> > > >> > On Tue, May 26, 2015 at 2:01 PM, Doug Turnbull < > >> > dturnb...@opensourceconnections.com> wrote: > >> > > >> > > How you have tie is fine. Setting tie to 1 might give you reasonable > >> > > results. You could easily still have scores that are just always an > >> > > order of magnitude or two higher, but try it out! > >> > > > >> > > BTW Anything you put in teh URL can also be put into a request > handler. > >> > > > >> > > If you ever just want to have a 15 minute conversation via hangout, > >> > > happy to chat with you :) Might be fun to think through your prob > >> > together. > >> > > > >> > > -Doug > >> > > > >> > > On Tue, May 26, 2015 at 1:42 PM, Steven White <swhite4...@gmail.com > > > >> > > wrote: > >> > > > >> > > > Hi Doug, > >> > > > > >> > > > I'm back to this topic. Unfortunately, due to my DB structer, and > >> > > business > >> > > > need, I will not be able to search against a single field (i.e.: > >> > > > using copyField). Thus, I have to use list of fields via "qf". > >> > > > Given this, I see you said above to use "tie=1.0" will that, more > or > >> > > > less, address this scoring issue? Should "tie=1.0" be set on the > >> > request handler like so: > >> > > > > >> > > > <requestHandler name="/select" class="solr.SearchHandler"> > >> > > > <lst name="defaults"> > >> > > > <str name="echoParams">explicit</str> > >> > > > <int name="rows">20</int> > >> > > > <str name="defType">edismax</str> > >> > > > <str name="qf">F1 F2 F3 F4 ... ... ...</str> > >> > > > <float name="tie">1.0</float> > >> > > > <str name="fl">_UNIQUE_FIELD_,score</str> > >> > > > <str name="wt">xml</str> > >> > > > <str name="indent">true</str> > >> > > > </lst> > >> > > > </requestHandler> > >> > > > > >> > > > Or must "tie" be passed as part of the URL? > >> > > > > >> > > > Thanks > >> > > > > >> > > > Steve > >> > > > > >> > > > > >> > > > On Wed, May 20, 2015 at 2:58 PM, Doug Turnbull < > >> > > > dturnb...@opensourceconnections.com> wrote: > >> > > > > >> > > > > Yeah a copyField into one could be a good space/time tradeoff. > It > >> > > > > can > >> > > be > >> > > > > more manageable to use an all field for both relevancy and > >> > > > > performance, > >> > > > if > >> > > > > you can handle the duplication of data. > >> > > > > > >> > > > > You could set tie=1.0, which effectively sums all the matches > >> > > > > instead > >> > > of > >> > > > > picking the best match. You'll still have cases where one > field's > >> > > > > score might just happen to be far off of another, and thus > >> > > > > dominating the summation. But something easy to try if you want > to > >> > > > > keep playing with dismax. > >> > > > > > >> > > > > -Doug > >> > > > > > >> > > > > On Wed, May 20, 2015 at 2:56 PM, Steven White > >> > > > > <swhite4...@gmail.com> > >> > > > > wrote: > >> > > > > > >> > > > > > Hi Doug, > >> > > > > > > >> > > > > > Your blog write up on relevancy is very interesting, I didn't > >> > > > > > know > >> > > > this. > >> > > > > > Looks like I have to go back to my drawing board and figure > out > >> > > > > > an alternative solution: somehow get those group-based-fields > >> > > > > > data into > >> > > a > >> > > > > > single field using copyField. > >> > > > > > > >> > > > > > Thanks > >> > > > > > > >> > > > > > Steve > >> > > > > > > >> > > > > > On Wed, May 20, 2015 at 11:17 AM, Doug Turnbull < > >> > > > > > dturnb...@opensourceconnections.com> wrote: > >> > > > > > > >> > > > > > > Steven, > >> > > > > > > > >> > > > > > > I'd be concerned about your relevance with that many qf > fields. > >> > > > Dismax > >> > > > > > > takes a "winner takes all" point of view to search. Field > >> > > > > > > scores > >> > > can > >> > > > > vary > >> > > > > > > by an order of magnitude (or even two) despite the attempts > of > >> > > query > >> > > > > > > normalization. You can read more here > >> > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > http://opensourceconnections.com/blog/2013/07/02/getting-dissed-by-dis > >> > > > max-why-your-incorrect-assumptions-about-dismax-are-hurting-search-rel > >> > > evancy/ > >> > > > > > > > >> > > > > > > I'm about to win the "blashphemer" merit badge, but ad-hoc > >> > > all-field > >> > > > > like > >> > > > > > > searching over many fields is actually a good use case for > >> > > > > > Elasticsearch's > >> > > > > > > cross field queries. > >> > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > https://www.elastic.co/guide/en/elasticsearch/guide/master/_cross_fiel > >> > > ds_queries.html > >> > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > http://opensourceconnections.com/blog/2015/03/19/elasticsearch-cross-f > >> > > ield-search-is-a-lie/ > >> > > > > > > > >> > > > > > > It wouldn't be hard (and actually a great feature for the > >> > > > > > > project) > >> > > to > >> > > > > get > >> > > > > > > the Lucene query associated with cross field search into > Solr. > >> > > > > > > You > >> > > > > could > >> > > > > > > easily write a plugin to integrate it into a query parser: > >> > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > https://github.com/elastic/elasticsearch/blob/master/src/main/java/org > >> > > /apache/lucene/queries/BlendedTermQuery.java > >> > > > > > > > >> > > > > > > Hope that helps > >> > > > > > > -Doug > >> > > > > > > -- > >> > > > > > > *Doug Turnbull **| *Search Relevance Consultant | OpenSource > >> > > > > Connections, > >> > > > > > > LLC | 240.476.9983 | http://www.opensourceconnections.com > >> > > > > > > Author: Relevant Search <http://manning.com/turnbull> from > >> > > > > > > Manning Publications This e-mail and all contents, including > >> > > > > > > attachments, is considered > >> > > to > >> > > > > be > >> > > > > > > Company Confidential unless explicitly stated otherwise, > >> > > > > > > regardless of whether attachments are marked as such. > >> > > > > > > On Wed, May 20, 2015 at 8:27 AM, Steven White < > >> > > swhite4...@gmail.com> > >> > > > > > > wrote: > >> > > > > > > > >> > > > > > > > Hi everyone, > >> > > > > > > > > >> > > > > > > > My solution requires that users in group-A can only search > >> > > against > >> > > > a > >> > > > > > set > >> > > > > > > of > >> > > > > > > > fields-A and users in group-B can only search against a > set > >> > > > > > > > of > >> > > > > > fields-B, > >> > > > > > > > etc. There can be several groups, as many as 100 even > more. > >> > > > > > > > To > >> > > > meet > >> > > > > > > this > >> > > > > > > > need, I build my search by passing in the list of fields > via > >> > > "qf". > >> > > > > > What > >> > > > > > > > goes into "qf" can be large: as many as 1500 fields and > each > >> > > field > >> > > > > name > >> > > > > > > > averages 15 characters long, in effect the data passed via > >> "qf" > >> > > > will > >> > > > > be > >> > > > > > > > over 20K characters. > >> > > > > > > > > >> > > > > > > > Given the above, beside the fact that a search for "apple" > >> > > > > translating > >> > > > > > > to a > >> > > > > > > > 20K characters passing over the network, what else within > >> > > > > > > > Solr > >> > > and > >> > > > > > > Lucene I > >> > > > > > > > should be worried about if any? Will I hit some kind of a > >> > limit? > >> > > > > Will > >> > > > > > > > each search now require more CPU cycles? Memory? Etc. > >> > > > > > > > > >> > > > > > > > If the network traffic becomes an issue, my alternative > >> > > > > > > > solution > >> > > is > >> > > > > to > >> > > > > > > > create a /select handler for each group and in that > handler > >> > > > > > > > list > >> > > > the > >> > > > > > > fields > >> > > > > > > > under "qf". > >> > > > > > > > > >> > > > > > > > I have considered creating pseudo-fields for each group > and > >> > > > > > > > then > >> > > > use > >> > > > > > > > copyField into that group. During search, I than can "qf" > >> > > against > >> > > > > that > >> > > > > > > one > >> > > > > > > > field. Unfortunately, this is not ideal for my solution > >> > > > > > > > because > >> > > > the > >> > > > > > > fields > >> > > > > > > > that go into each group dynamically change (at least once > a > >> > > month) > >> > > > > and > >> > > > > > > when > >> > > > > > > > they do change, I have to re-index everything (this I have > >> > > > > > > > to > >> > > > avoid) > >> > > > > to > >> > > > > > > > sync that group-field. > >> > > > > > > > > >> > > > > > > > I'm using "qf" with edismax and my Solr version is 5.1. > >> > > > > > > > > >> > > > > > > > Thanks > >> > > > > > > > > >> > > > > > > > Steve > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > -- > >> > > > > *Doug Turnbull **| *Search Relevance Consultant | OpenSource > >> > > Connections, > >> > > > > LLC | 240.476.9983 | http://www.opensourceconnections.com > >> > > > > Author: Relevant Search <http://manning.com/turnbull> from > Manning > >> > > > > Publications This e-mail and all contents, including > attachments, > >> > > > > is considered to > >> > > be > >> > > > > Company Confidential unless explicitly stated otherwise, > >> > > > > regardless of whether attachments are marked as such. > >> > > > > > >> > > > > >> > > > >> > > > >> > > > >> > > -- > >> > > *Doug Turnbull **| *Search Relevance Consultant | OpenSource > >> > > Connections, LLC | 240.476.9983 | > http://www.opensourceconnections.com > >> > > Author: Relevant Search <http://manning.com/turnbull> from Manning > >> > > Publications This e-mail and all contents, including attachments, is > >> > > considered to be Company Confidential unless explicitly stated > >> > > otherwise, regardless of whether attachments are marked as such. > >> > > > >> > > >> > > ************************************************************************* > >> > This e-mail may contain confidential or privileged information. > >> > If you are not the intended recipient, please notify the sender > >> > immediately and then delete it. > >> > > >> > TIAA-CREF > >> > > ************************************************************************* > >> > > >> >
