Hi Hugo, Have a look at Rails caching. Here is a tutorial http://railscasts.com/episodes/115-caching-in-rails-2-1
All the best, Fidel. On Tue, Apr 20, 2010 at 2:55 PM, Pieter Hugo <[email protected]> wrote: > Hi > > I am looking to speed up my rails application and am working through all > the SQL queries and trying to remove unnecessary queries. > > I thought of the following and would love to hear whether it is > possible. > > I have one (smallish - about 40 records) table which only gets read by > my app - no writing. It gets read a lot though. Would it be possible to > preload this table into memory (as a kind of global global dataset) when > the server starts up? This would save me at least one sql query on every > server trip. > > Is this even necessary? Maybe rails - (or the database?) automatically > caches things like this? > > Your thoughts and suggestions are most welcome. > > Pieter Hugo > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

