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.