Thanks Mikhail for the explanation. With Regards Aman Tandon
On Fri, Mar 27, 2015 at 3:40 PM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > 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> >