Solr at search

gistfile1.rb

  def find_solr_at_connections
    users = {}    
    persons.each do |person|        
	users[person.id] = person.username
    end
    values = []
    i = 0
    persons.each do |person|
      i += 1
      t1 = Time.now
      search = FeedEntry.search do        
        without(:person_id,person.id) # No self referencing
        fulltext "@#{person.username}" #Find those Feeds that mention this person
	paginate :page => 1, :per_page => 1000000 #Make sure we dont paginate	
      end
      j = 0
      search.results.each do |result|
        if users.keys.include?(result.person_id) && result.person_id != person.id # No self @
          if result.retweet_ids == [] && !result.text.include?("RT") && result.text.include?("@#{person.username} ")
            j += 1
            values << [users[result.person_id], person.username, 1]
          end
        end
      end
      t2 = Time.now      
      puts "Person #{i} #{person.username}. Time per person: #{t2- t1}. Total pages #{search.results.total_pages}. Total results #{search.total}. Filtered: #{j}"
    end
    #Aggregate 
    hash = values.group_by { |first, second, third| [first,second] }    
    hash.map{|k,v| [k,v.count].flatten}    
  end