Ok, sphinx upgraded to 0.9.9
rake ts:rebuild run with "has local_start_time" defined in the index:
> Events::Event.search_count
=> 60397
...so that looks a little better.
Now when I run the query without the :with clause, it returns a
reasonable result (which it wasn't doing before), so that's an improvement:
Events::Event.search('amanda' , :start=>true).total_entries
=> 205
However, when I try and use the :with clause and a time range over the
last year, I get zero results:
Events::Event.search('amanda' , :start=>true,
:with=>{:local_start_time=>1.year.ago..Time.now}).total_entries
=> 0
So, for a sanity check, I ran the following:
ree-1.8.7-2010.02 > ids = Events::Event.search('amanda' , :start=>true,
:per_page=>400 ).collect{|res| res.id}
ree-1.8.7-2010.02 > ids.count
=> 205
Now I've got an array of event_ids for the full search result ( I guess
I could have used search_for_ids, but I wanted to compare apples to
apples). So, now I'll do just a standard Rails model count query on the
above ids, and include the date range, which /should/ be the functional
equivalent of the Sphinx query using the :with clause.
ree-1.8.7-2010.02 > Events::Event.count(:all, :conditions=>["id in (?)
and local_start_time between ? and ?",ids ,1.year.ago, Time.now])
=> 142
On 10/14/10 11:39 PM, Pat Allan wrote:
Ah, bugger. Well, let's see if Sphinx 0.9.9 helps matters.
--
You received this message because you are subscribed to the Google Groups "Thinking
Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
