I have tried my best to minimize the queries but there are still some queries for the belongs_to associations. For example if I have a table called locations and locations belong to businesses it does a paginated query to locations and then does an eager load of businesses by doing a select from business where id in (.....). This is the standard rails way of pulling the related records.
In my case it would be more efficient to just pull all the businesses because there are not that many of them and cache them. From what I can gather there is no way to configure AS to do this. As I mentioned in the earlier emails most of my data is relatively static so it could be cached easily especially if there was an intelligent way to bust the cache when records are changed. Also as I mentioned some of the partials take a very long time to render so maybe those could be cached. Anyway long and short of it is that I know my data and would like to see if there is any way I can intelligently cache either the partials or the queries themselves. On Wed, Mar 6, 2013 at 11:32 PM, Sergio Cambra <[email protected]> wrote: > Check number of queries, do you have association columns? are you eager > loading them? if there are few associated records it's better to eager load > them, if they are many records it's better not to eager load them, even > display only count and use counter_cache. Do you have some column overrides? > Are they slow? > > El Miércoles, 6 de marzo de 2013 14:28:41 Tim Uckun escribió: >> Hey guys. >> >> Hate to bump my own post but any ideas about how I can make AS more >> performant. >> >> Thanks. >> >> On Tue, Feb 26, 2013 at 9:45 PM, Tim Uckun <[email protected]> wrote: >> > Hey guys. >> > >> > I have been searching through the list and there are a couple of >> > questions about caching but no real answers. Much (if not all) of the >> > data in my admin area is cachable for a substantial amount of time and >> > I am wondering how to go about doing this. Is there a guide someplace >> > on performance enhancements to AS. >> > >> > Along with the queries It would be really helpful if the partials >> > could be cached as well. Some of them take very long to render. >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/app >> > /views/active_scaffold_overrides/_list_record.html.erb> >> > (1195.4ms) >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/ap >> > p/views/active_scaffold_overrides/_list_pagination_links.html.erb> >> > (2.6ms) >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/ap >> > p/views/active_scaffold_overrides/_list_pagination.html.erb> >> > (20.4ms) >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/ap >> > p/views/active_scaffold_overrides/_list.html.erb> >> > (1602.4ms) >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/ap >> > p/views/active_scaffold_overrides/_list_with_header.html.erb> >> > (1762.3ms) >> > >> > Rendered >> > /Users/tim/.rvm/gems/ree-1.8.7-2012.02/gems/active_scaffold-3.3.0.rc/ap >> > p/views/active_scaffold_overrides/list.html.erb> >> > within layouts/admin (1776.4ms) >> > >> > >> > Maybe this is a 1.8.7 issue (still haven' t migrated yet) but these >> > seem really slow to me. > > -- > You received this message because you are subscribed to the Google Groups > "ActiveScaffold : Ruby on Rails plugin" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/activescaffold?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/activescaffold?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
