I'm trying to wrap my head around the best practices way of correlating Solr documents with database items.
Let's say I have a database containing people, groups, and projects (these all have different fields). I want to index these different kinds of objects with a view to eventually present search results from all three types mashed together and sorted by relevance. Using separate indices (and thus separate Solr processes) would make mashing the results together very difficult so I'm guessing I just add the separate fields to the schema along with an 'object_type' field or equivalent? Secondly should I just store the database row id for each object (while still indexing the field contents) so a query on the index returns a list of id's that I can then fetch from the database? Thanks! -- View this message in context: http://www.nabble.com/Newbie-question-about-Solr-use-in-web-applications-tp14328925p14328925.html Sent from the Solr - User mailing list archive at Nabble.com.
