diff options
| author | francis <francis> | 2008-09-05 09:16:23 +0000 |
|---|---|---|
| committer | francis <francis> | 2008-09-05 09:16:23 +0000 |
| commit | 027c8d1bf87b276d4bf85c57f23f7191d620356f (patch) | |
| tree | c8f379da9ddb62848ad0de3adad24de179882f93 /app/controllers/general_controller.rb | |
| parent | 25c151895f244717931594fdec5cdde7933ec41b (diff) | |
Random was too slow.
Diffstat (limited to 'app/controllers/general_controller.rb')
| -rw-r--r-- | app/controllers/general_controller.rb | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/app/controllers/general_controller.rb b/app/controllers/general_controller.rb index d0b6f8999..b4de641b7 100644 --- a/app/controllers/general_controller.rb +++ b/app/controllers/general_controller.rb @@ -5,7 +5,7 @@ # Copyright (c) 2008 UK Citizens Online Democracy. All rights reserved. # Email: francis@mysociety.org; WWW: http://www.mysociety.org/ # -# $Id: general_controller.rb,v 1.37 2008-09-05 09:05:05 francis Exp $ +# $Id: general_controller.rb,v 1.38 2008-09-05 09:16:23 francis Exp $ class GeneralController < ApplicationController @@ -41,7 +41,15 @@ class GeneralController < ApplicationController # New, improved front page! def new_frontpage @popular_bodies = PublicBody.find(:all, :select => "*, (select count(*) from info_requests where info_requests.public_body_id = public_bodies.id) as c", :order => "c desc", :limit => 8) - @random_requests = InfoRequest.find(:all, :order => "random()", :limit => 8, :conditions => ["described_state = ? and prominence = ?", 'successful', 'normal'] ) + + # This is too slow + #@random_requests = InfoRequest.find(:all, :order => "random()", :limit => 8, :conditions => ["described_state = ? and prominence = ?", 'successful', 'normal'] ) + + # Get somesuccessful requests + query = 'variety:response (status:successful OR status:partially_successful)' + sortby = "described" + @xapian_object = perform_search([InfoRequestEvent], query, sortby, 'request_collapse', 8) + @successful_requests = @xapian_object.results.map { |r| r[:model].info_request } end # Just does a redirect from ?query= search to /query |