Re: [Rails] working with models, efficent queries..

You need pagination, visit this [1]

[1]: http://railscasts.com/episodes/254-pagination-with-kaminari

On Wed, Dec 11, 2013 at 4:29 AM, Colin Williams <ke7cfn@gmail.com> wrote:

 i have a model with 35000 entries in the database. I was using a unique string as the primary key. Right now I am using the order method to return the model objects in
 order. I'd like to know what is good practice ( efficient ) and how to return X entries at a time instead of all at once. Right now I'm using the index method of a controller along with the order method to return the entries, and then iterating through them in the view.

 class StoreController < ApplicationController
   def index
     @dicts = Dict.order(:key)
   end
 end

 <h1>Store#index</h1>
 <p>Find me in app/views/store/index.html.erb</p>
 <% @dicts.each do |word| %>
   <div class='entry'>
     <%= word.key %>
   </div>
 <%end %>


I'd also like to know a little more about how conrtrollers work with the database. Is a new store controller instanced everytime a route is directed to it? If so am I continually querying the database for those 35000 entries, or is one instance of the controller generated, and one request made. I have read some of the rails guides, and read quite a bit of agile web dev with rails 4, but haven't found the answer to my questions. Do you think you know a reference you would recommend I read?

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/0b1b8461-ca5a-4442-acd4-b32fbfac1bf4%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

 greatghoul - Ask and Learn!

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAFoKNZODPwjmoK%2BKa_CD%3DLYs4FxPQAZG0gPe2HEhAJP%2BHSndVQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.