I/my team will have to look at that and decode it,LOL! I get some of it. The database version returns 1 row, with the answer.
What does this return and how fast is it on BIG indexes? PS, that should have been: . . . date_column2 < :end_date; . Dennis Gearon Signature Warning ---------------- It is always a good idea to learn from your own mistakes. It is usually a better idea to learn from others’ mistakes, so you do not have to make them yourself. from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036' EARTH has a Right To Life, otherwise we all die. --- On Mon, 10/18/10, Chris Hostetter <hossman_luc...@fucit.org> wrote: > From: Chris Hostetter <hossman_luc...@fucit.org> > Subject: Re: count(*) equivilent in Solr/Lucene > To: solr-user@lucene.apache.org > Date: Monday, October 18, 2010, 10:26 PM > : > : SELECT > : COUNT(*) > : WHERE > : date_column1 > :start_date AND > : date_column2 > :end_date; > > q=*:*&fq=column1:[start TO > *]&fq=column2:[end TO *]&rows=0 > > ...every result includes a total count. > > -Hoss >