Dear Wiki user, You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.
The following page has been changed by Lance Norskog: http://wiki.apache.org/solr/WhyUseSolr ------------------------------------------------------------------------------ - Assuming the user has a relational DB, why use Solr? + Assuming the user has a relational DB, why use Solr? If your use case requires a person to type words into a search box, you want a text search engine like Solr. - Databases and Solr have complementary strengths and weaknesses. + Databases and Solr have complementary strengths and weaknesses. SQL supports very simple wildcard-based text search with some simple normalization like matching upper case to lower case. The problem is that these are full table scans. In Solr all searchable words are stored in an "inverse index", which searches orders of magnitude faster. For a more complete description of Solr's features, see http://lucene.apache.org/solr/features.html (link) ||||||<tablestyle="width: 80%">'''Solr v.s. Relational Database'''|| ||Lucene||<style="width: 30%;"> Solr ||<style="width: 30%; text-align: center;">Relational DB||
