I submitted a patch to lighthouse which caches columns ("SHOW FIELDS")
for has_and_belongs_to_many associations.  See the patch and ticket
at:  
http://rails.lighthouseapp.com/projects/8994/tickets/1738-caching-columns-for-has_and_belongs_to_many

The patch is simple and unobtrusive, and resulted in a 25% performance
increase (response time, CPU load, and database load all dropped by
about 25%) in my companies Rails app (http://teamsporttech.com) which
serves over 500 websites for sports teams.

Further details are at
http://lukeludwig.com/blog/2009/01/08/rails-patch-for-caching-show-fields-for-has_and_belongs_to_many-associations

If someone could take a look at this patch that would be great,

Luke

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-core+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to