Hello, we are having significant performance problems with date queries on our production server. we are using SOLR 1.4 (will be upgrading to latest version in the near future) and our index size is around 4GB with 2 million documents. for e.g: the query "tag:obama AND expirationdate:[2012-02-21T00:00:00Z TO *] AND publicationdate:[* TO 2012-02-21T00:00:00Z]" takes 1113ms and if we remove the dates "tag:obama" it takes only 98ms.
we tried storing the date as a long data field in the form "YYYMMDDHHMMSS" and we are seeing improvement in the query times, but it's not significant. I have read somewhere is we use "TrieDate" field instead "Date" it would help. Do you guys think the performance improvement would be significant? if not, do you see if there is any other alternative solution to speed up the date queries? I appreciate your response. -- View this message in context: http://lucene.472066.n3.nabble.com/date-queries-too-slow-tp3794345p3794345.html Sent from the Solr - User mailing list archive at Nabble.com.
