lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Tandon <amantandon...@gmail.com>
Subject Re: Database vs Solr : ID based filtering
Date Fri, 27 Mar 2015 08:35:44 GMT
>
> so you’ll end up forever invalidating your cache.


What if we have 1 million ids assigned to the different user and each user
daily performs the query on solr. Then will it be there forever?

With Regards
Aman Tandon

On Fri, Mar 27, 2015 at 1:50 PM, Upayavira <uv@odoko.co.uk> wrote:

> The below won’t perform well. You’ve used a filter query, which will be
> cached, so you’ll end up forever invalidating your cache.
>
> Better would be http://localhost:8983/solr/select?q=id:153
>
> Perhaps better still would be http://localhost:8983/solr/get?id=153
>
> The latter is a “real time get” which will return a document that hasn’t
> even been soft-committed yet.
>
> As to which performs better, I’d encourage you to set up a simple
> experiment, and try it out.
>
> Upayavira
>
> On Fri, Mar 27, 2015, at 06:56 AM, Aman Tandon 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
>

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