Hi,

From: Ronny Hanssen <[email protected]>
Subject: [Hobo Users] Duplicate SQL-queries in hobo_index finder
Date: Wed, 18 May 2011 16:35:25 -0700 (PDT)

> As you can see, hobo/rails now executes the Job select-statement twice. One 
> time similar to the first select with a limit, as expected. The second 
> select is unexpected though.

reproduced more simply with:

>> User.paginate(:page => 1); nil
  User Load (2.6ms)  SELECT "users".* FROM "users" LIMIT 30 OFFSET 0

>> User.order("id").paginate(:page => 1); nil
  User Load (2.7ms)  SELECT "users".* FROM "users" ORDER BY id LIMIT 30 OFFSET 0
  User Load (2.0ms)  SELECT "users".* FROM "users" ORDER BY id desc

I filed this issue as

  
https://hobo.lighthouseapp.com/projects/8324-hobo/tickets/952-duplicated-sql-queries-when-paginating

and I'm looking for a solution.

-----
Tomoaki Hayasaka <[email protected]>

-- 
You received this message because you are subscribed to the Google Groups "Hobo 
Users" 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/hobousers?hl=en.

Reply via email to