Never mind, I just figured it out. In case anyone else runs into this, here's the explanation: if the fields you're indexing are blank, that record is actually skipped. In my case, only 67 of my User records had either a first or a last name.
On Aug 10, 7:37 pm, sergiu <[email protected]> wrote: > Hi guys, > > I have the following index definition: > > define_index do > indexes first_name > indexes last_name > has role_id > where "state = 1 AND role_id = 6" > end > > When I run rake thinking_sphinx:rebuild (or reindex), I get this > output: > > indexing index 'user_core'... > collected 418 docs, 0.0 MB > collected 134 attr values > sorted 0.0 Mvalues, 100.0% done > sorted 0.0 Mhits, 100.0% done > total 418 docs, 987 bytes > total 4.749 sec, 207 bytes/sec, 88.00 docs/sec > > From what I get here, there should be 418 users indexed. But when I > run a search count, I get this: > > ruby-1.8.7-p334 :035 > User.search_count > => 67 > > I tried to figure out why I don't get the right number of users, > which, if I do an SQL select using the condition "state = 1 AND > role_id = 6" is 418 users; what am I missing here. Pat, any ideas? :)) > > Thank you! -- 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.
