also if your index is a bit large, invest in an architecture which makes reindexing very easy, as you will probably need to change the schema and reindex multiple times
--ufuk yilmaz ________________________________ From: Walter Underwood <wun...@wunderwood.org> Sent: Friday, April 5, 2024 8:59 PM To: users@solr.apache.org <users@solr.apache.org> Subject: Re: Date syntax : Filter by month independent of the year This is a great example of a general technique to make Solr fast. Do the parsing and selection at index time to make the query as simple as possible. —wunder > On Apr 5, 2024, at 10:55 AM, rajani m <rajinima...@gmail.com> wrote: > > yeah, makes sense, thank you. > > On Fri, Apr 5, 2024 at 1:24 PM Walter Underwood <wun...@wunderwood.org> > wrote: > >> That is what I was going to suggest. Make a month field. —wunder >> >>> On Apr 5, 2024, at 8:22 AM, Alexandre Rafalovitch <arafa...@gmail.com> >> wrote: >>> >>> If you know you are going to search by it, clone the field without >> storage >>> and preprocess to just leave the months behind. That's like 12 possible >>> values - super efficient for filtering. Or set all years to year 1 in the >>> copy if you are still doing day as well. >>> >>> Regards, >>> Alex. >>> >>> On Fri, 5 Apr 2024 at 10:44, rajani m <rajinima...@gmail.com> wrote: >>> >>>> Hi Solr Users, >>>> >>>> Any creative date range syntax that allows filters by month >> independent >>>> of the year? >>>> Such as date_added:[*-01-29T00:00:00Z TO *-04-09T00:00:00Z] >>>> >>>> The date format in the index is tries/kd-trees so thinking this could be >>>> possible. Appreciate any thoughts. <fieldType name="pdate" class= >>>> "solr.DatePointField" docValues="true"/> >>>> >>>> Thank you for your time, >>>> Rajani >>>> >> >>
