Katie, you really need to move the User.all requests outside your view as I tried to show. Without doing that, your page absolutely can't load in a decent time. If you look at the logs, you should see all the DB queries being generated and how long each take.
Matt On Mar 14, 2013 7:17 AM, "KT" <[email protected]> wrote: > Everyone, thanks for all your tips. I will go through them today. Not > sure pagination will help, since users need to have the ability to modify > multiple records at once. The javascript sort isn't necessary, but helpful > with all those records. I'm going to add a search filter, too; maybe that > will help. I think the :includes is where I'll start. Thanks again! > > > On Wednesday, March 13, 2013 12:02:39 PM UTC-7, KT wrote: >> >> Hi all - can anyone tell me what I'm doing so wrong that it takes 7-9 >> minutes to load this form view? >> >> https://github.com/sdstoic/**vits/blob/master/app/views/po_** >> renewals/index.html.erb<https://github.com/sdstoic/vits/blob/master/app/views/po_renewals/index.html.erb> >> >> The table holds about 2700 records, and has many columns, but still... >> should it take that long? >> >> Ruby 1.9.3 / Rails 3.0.3 >> Apache / Passenger / MySQL >> >> Thanks in advance for any help. >> Katie >> > -- > -- > SD Ruby mailing list > [email protected] > http://groups.google.com/group/sdruby > --- > You received this message because you are subscribed to the Google Groups > "SD Ruby" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
