group_by user_id


I want to know if this is possible with sphinx.

Let's say I have this table.

id | user_id | title

you can use any function in group_by clause, for example you can write
something like

function_returning_found_times}.each do |count_of_times, sub_collection|

next if count_of_times<SOME_VALUE #
user_ids = sub_collection.collect(&:user_id).join(',')
users_cnt = sub_collection.size



With Rails or does sphinx handle the calculations all together?

Anton Anykeyev wrote in post #968296: