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 ------------------------------------------------------------------------------ ||||||<tablestyle="width: 80%">'''Solr v.s. Relational Database'''|| ||Lucene||<style="width: 30%;"> Solr ||<style="width: 30%; text-align: center;">Relational DB|| - ||Text Search|||||| + ||Text Search||Very strong||Weak or Medium|| - ||Features|||||| + ||Features||Few||Many|| - ||Deployment Complexity|||||| + ||Deployment Complexity||Medium||Low|| - ||Administration Tools|||||| + ||Administration Tools||Weak||Strong|| - ||Monitoring Tools|||||| + ||Monitoring Tools||Weak||Very Strong|| - ||Scaling Tools|||||| + ||Scaling Tools||Medium||Strong|| - ||Support Availability|||||| + ||Support Availability||Weak||Strong|| - ||Schema Flexibility|||||| + ||Schema Flexibility||Rebuild||Immediate|| - ||Indexing Facilities|||||| - ||Lookup Speed|||||| + ||Indexing Speed||Slow||Faster and adjustable|| + ||Query Speed||Fast||Medium|| - ||Row Addition/Extraction Speed|||||| + ||Row Addition/Extraction Speed||Slow||Fast|| - ||Query Speed|||||| - ||Partial Record Modification|||||| + ||Partial Record Modification||No||Yes|| - ||Time between Addition and Query|||||| + ||Time between Addition and Query||Slow||Fast|| + ||Access to internal data structures||High||Low|| + From a database perspective, a Lucene index can be thought of as one DB table with very fast lookups and interesting enhancements for text search. This index is relatively expensive in space and creation time. Solr wraps this API with a full-featured front end, providing these additions: + + * schema design and text processing features that match most Lucene deployments + * clean deployment as a web service for indexing and searching + * convenient scalability across multiple servers + * learning curve & adoption improvement of ~2 orders of magnitude +
