eager loading optimization

rubyonrails-talk
1

I have a phrase model, a definition model, and a children model a phrase has many definitions, a definition has many children

currently when i am doing a find i have an include that looks like

Phrase.find(:all,:include => [{:definitions => :children}] , :conditions => 'foo')

but for the most part I only want the first definition, and its associated children. The loading of all of the additional definitions and their associated children is killing my site load time (but not more than eliminating the :include all together).

Is there a way to get only the first definition under an associated phrase ( the definitions are ordered by rank) without having to write my own SQL ??

Rails 2.1.0 and Ruby 1.8.6

2

Richard Schneeman wrote:

I have a phrase model, a definition model, and a children model a phrase has many definitions, a definition has many children

currently when i am doing a find i have an include that looks like

Phrase.find(:all,:include => [{:definitions => :children}] , :conditions => 'foo')

but for the most part I only want the first definition, and its associated children. The loading of all of the additional definitions and their associated children is killing my site load time (but not more than eliminating the :include all together).

Is there a way to get only the first definition under an associated phrase ( the definitions are ordered by rank) without having to write my own SQL ??

Rails 2.1.0 and Ruby 1.8.6

Tricky, but investigate something like:

class Phrase < ActiveRecord::Base    has_one :top_ranked_definition, :class_name => 'Definition',            :conditions => <<-END      definitions.rank =      (select max(rank) from definitions where phrase_id = phrases.id)    END

Phrase.find :all, :include => {:top_ranked_definition => :children},                    :conditions => 'foo'