On Oct 19, 2010, at 2:09 AM, Dennis Gearon wrote: > 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?
rows=0 returns 0 rows, but the total count will be returned. You can do rows=0 with any query to get the total number of matches. > > 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 >> -------------------------- Grant Ingersoll http://www.lucidimagination.com/ Search the Lucene ecosystem docs using Solr/Lucene: http://www.lucidimagination.com/search