I guess let's keep in mind that you've got the WHERE clause as well - filtering out deleted/creator-less events. So I guess that accounts for the difference between Event.count and search_count without the attribute.
But I've not seen such a massive difference when an attribute is added (there should be no difference!) What version of Sphinx are you using? -- Pat On 15/10/2010, at 12:51 PM, Jeff Luckett wrote: > Pat, > > Thanks for looking into it with me. > > First, for reference: > ree-1.8.7-2010.02 > Events::Event.count > => 87094 > > Index defined WITH "has local_start_time": > > ree-1.8.7-2010.02 > Events::Event.search_count > => 3072 > > Index defined WITHOUT "has local_start_time" > > ree-1.8.7-2010.02 > Events::Event.search_count > => 60397 > > Interesting... > > -Jeff > > On 10/14/10 9:23 PM, Pat Allan wrote: >> Hi Jeff >> >> I've no idea what's causing this, but let's start with a clean slate: >> rake ts:rebuild >> >> Then what's the result of Events::Event.search_count? >> >> And when you remove the attribute and run 'rake ts:rebuild' again, what's >> the new overall count? >> > > -- > 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. > -- 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.
