So I will have a solr field that contains "years", ie, "1990", "2010",
maybe even "1492", "1209" and "907"/"0907".
I will be doing range limits over this field. Ie, [1950 TO 1975] or
what have you. The data represents publication dates of books on a
large library shelves; there will be around 3 million documents, with
the range of data being concentrated in recent years, but with a long
tail stretching off into the past.
So it seems to me clear that I should use a trie field of some type, to
efficiently accomodate the range querries.
It seems to me that I probably don't need/want an actual date field,
since the data isn't complex to demand it, it's just a four-digit year.
So that pretty much leaves storing as a trie integer, or as a trie
string. Any advice on which is probably better in this case? Or on how
to set up the trie field for this kind of data? Thanks for any,
Jonathan