lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From user 01 <user...@gmail.com>
Subject Re: Fix sort order within an index ?
Date Tue, 08 Oct 2013 12:33:15 GMT
@Upayavira:

>q=topic:x1&rows=20&sort=id desc
>Or
>q=topic:x1&rows=20&sort=timestamp desc
>
>Will get you what you ask for.

yeah I know that I could use SORT & that will work but I asked just for an
optimized way. Also that ticket has been fixed, so shouldn't be able to now
make use of the fixed sort order?


On Tue, Oct 8, 2013 at 11:59 AM, Upayavira <uv@odoko.co.uk> wrote:

>
>
> On Mon, Oct 7, 2013, at 11:09 PM, user 01 wrote:
> > Any way to store documents in a fixed sort order within the indexes of
> > certain fields(either the arrival order or sorted by int ids, that also
> > serve as my unique key), so that I could store them optimized for
> > browsing
> > lists of items ?
> >
> > The order for browsing is always fixed & there are no further filter
> > queries. Just I need to fetch the top 20 (most recently added) document
> > with field value topic=x1
> >
> > I came across this article & a JIRA issue which encouraged me that
> > something like this may be possible:
> >
> > http://shaierera.blogspot.com/2013/04/index-sorting-with-lucene.html
> >
> > https://issues.apache.org/jira/browse/LUCENE-4752
>
> That ticket is an optimisation. If your IDs are sequential, you can sort
> on them. Or you can add a timestamp field with a default of NOW, and
> sort on that.
>
> q=topic:x1&rows=20&sort=id desc
> Or
> q=topic:x1&rows=20&sort=timestamp desc
>
> Will get you what you ask for.
>
> The above ticket might just make it a little faster.
>
> Upayavira
>

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