So, you keep your mssql database, you just don't use it for searches - that'll relieve some of the load. Searches then all go through SOLR & its Lucene indexes. If your various tables need SQL joins, you specify those in the DataImportHandler (DIH) config. That way, when SOLR indexes everything, it indexes the data the way you want to see it.
-- SO .... by this you mean we keep mssql as we do!!.... But we use the website to run through SOLR.... SOLR will then handle the indexing and retrieval of data from its own index's, and will make its own calls to our MSSQL server when required....(i.e updating/adding to indexs..) Am I on the right tracks there now! So MSSQL becomes the datastore SOLR becomes the search engine... -- View this message in context: http://lucene.472066.n3.nabble.com/Newbie-SolR-Need-advice-tp4074746p4074889.html Sent from the Solr - User mailing list archive at Nabble.com.
