lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Khludnev <mkhlud...@griddynamics.com>
Subject Re: Database vs Solr : ID based filtering
Date Fri, 27 Mar 2015 10:10:19 GMT
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.10@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>
<mkhludnev@griddynamics.com>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message