Solr Best Practice Configuration
Good Morning. I have now been through the various Solr tutorials and read the SOLR 3 Enterprise server book. Im not at the point of figuring out if Solr can help us with a scaling problem. Im looking for advice on the following scenario any pointers or references will be great: I have two sets of distinct data: Advert Advertiser An Advertiser has many Adverts in the db looking like Advert { id field a field b advertiser_id } Advertiser { id field c field d lat long } So ive followed some docs and ive created a DIH which pulls all this into one SOLR index. Which is great. The problem im looking at is that we have a massive churn on Advertiser updates and with the one index i dont think it will scale (Correct me if im wrong). Would it be possible to have two seperate cores each with its own index and then when issuing queries the results are returned as they are in a single core setup. Im basically looking for some pointers telling me if im going in the right direction. I dont want to have to update 5 adverts when a advertiser simply updated field c. This is a problem we have with our current search. Thanks Ben -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Best-Practice-Configuration-tp3572492p3572492.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr Best Practice Configuration
Thanks for the replies guys. The Advert index would be around 1 million records and we have a churn of around 400K record changes per day. Our current system does around 400K updates a day to the index and we have over 72 million searches on the index. Im more wondering what type of configuration i would need to be able to get results back which include both the advert record and the advertiser record as one document. If that sheds any more light on the situation. Thanks Ben -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Best-Practice-Configuration-tp3572492p3572894.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr Best Practice Configuration
What does (3) imply? You will not be able to facet or sort or group on Adverts using any of the Advertiser fields (as they reside in a different index core). In relation to my last reply this is exactly what i need to do. Return all adverts where a postcode (translated to lang/long) is within a bounding box. As the lat/long is on the advertiser record and fields in the advertiser contain information needed in the displaying of the advert. Thanks Ben -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Best-Practice-Configuration-tp3572492p3572901.html Sent from the Solr - User mailing list archive at Nabble.com.