> Is there a way to configure Solr to accept POST queries (instead of GET > only?). > Or: is there some other way to make Solr accept queries longer than 2,000 > characters? (Up to 10,000 would be nice) Solr accepts POST queries by default. I switched to POST for exactly the same reason. I use Solr 1.4 ( trunk version ) though.
> I have a Solr 1.3 index (served by Tomcat) of People, containing id, name, > address, description etc. This works fine. > Now I want to store and retrieve Events (time location, person), so each > person has 0 or more events. > As I understood it, there is no way to model a has-many relation in Solr (at > least not between two structures with more than 1 properties), so I decided > to store the Events in a separate mysql table. > An example of a query I would like to do is: give me all people that will > have an Event on location x coming month, that have .... in their > description. > I do this in two steps now: first I query the mysql table, then I build a > solr query, with a big OR of all the ids. > The problem is that this can generate long (too long) querystrings. Another option would be to put all your event objects (time, location, person_id, description) into Solr index ( normalization ) Then you can generate Solr query "give me all events on location x coming month that have smth in their description" and asks Solr to return facets values for field person_id. Solr will return all distinct values of field "person_id" that matches the query with count values. Then you can take list of related person_ids and load all persons from MySQL database using SQL "in IN ()" clause.
