for the single where clause RDBMS with index performs comparable same as inverted index. Inverted index wins on multiple 'where' clauses, where it doesn't need composite indices; multivalue field is also its' intrinsic advantage. More details at http://www.slideshare.net/lucenerevolution/what-is-inaluceneagrandfinal
On Fri, Mar 27, 2015 at 9:56 AM, Aman Tandon <amantandon...@gmail.com> wrote: > Hi, > > Does an ID based filtering on solr will perform poor than DB? > > <field name"id" type"string" indexed="true" stored="true"> > > - http://localhost:8983/solr/select?q=*&fq=id:153 > > *OR* > > - select * from TABLE where id=153 > > > With Regards > Aman Tandon > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
