On Tue, Jan 5, 2010 at 11:16 AM, dipti khullar <dipti.khul...@gmail.com>wrote:
> > This assettype is variable. It can have around 6 values at a time. > But this is true that we apply facet mostly on just one field - assettype. > > Ian has a good point. You are faceting on assettype and you are also filtering on it so you will get only one facet value "Gallery" with a count equal to numFound. > Any idea if the use of date range queries is expensive? Also if Shalin can > put in some comments on > "sorting by date was pretty rough on CPU", I can start analyzing sort by > date specific queries. > > This is a range search and not a sort. I don't know if range search on dates is especially costly compared to a range search on any other type. But I do know that trie fields in Solr 1.4 are much faster for range searches at the cost of more tokens in the index. With a date field, instead of using NOW, you should always try to round it down to the coarsest interval you can use. So if it is possible to use NOW/DAY instead of NOW, you should do that. The problem with querying on NOW is that it is always unique and therefore the query can never be cached (actually, it is cached but can never be hit). If you use NOW/DAY, the query can be cached for a day. -- Regards, Shalin Shekhar Mangar.
