Hi, This may be a silly question to ask. But as performance issues start popping up I had no other go other than searching for a solution. I''ve application.html.erb where i''ve defined the layout of my whole project, where i''ve so many db calls and everything which is a one time call that must happen for the whole layout. In the main area i''ve <%= yield %> I want only this part to be refreshed/changed whenever i go back and forth of the pages, but the problem is, the whole page is getting refreshed everytime which is consuming hell a lot of time as i''m doing so many db calls for the common layout. How to achieve my requirement and improve the performance? And if someother tips are there the improve the performance in ruby on rails Thanks in advance :) -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You shouldn''t be making database calls from the view. If you''re making calls for the application layout then I''d add these to the application controller and call them with a before_filter (anyone know a better way ?) If the objects you are calling are the same from one page to the next you could try using an "or equals" so instead of always calling @current_user = User.find session[:user_id] you could write @current_user ||= User.find session[:user_id] This should mean that the database call is only made if @current_user is nil does that help? On Apr 20, 1:33 pm, Preethi Sivakumar <rails-mailing-l...@andreas- s.net> wrote:> Hi, > This may be a silly question to ask. But as performance issues start > popping up I had no other go other than searching for a solution. > I''ve application.html.erb where i''ve defined the layout of my whole > project, where i''ve so many db calls and everything which is a one time > call that must happen for the whole layout. > In the main area i''ve > > <%= yield %> > > I want only this part to be refreshed/changed whenever i go back and > forth of the pages, but the problem is, the whole page is getting > refreshed everytime which is consuming hell a lot of time as i''m doing > so many db calls for the common layout. > > How to achieve my requirement and improve the performance? > And if someother tips are there the improve the performance in ruby on > rails > Thanks in advance :) > -- > Posted viahttp://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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Gavin Morrice wrote:> You shouldn''t be making database calls from the view. > If you''re making calls for the application layout then I''d add these > to the application controller and call them with a before_filter > (anyone know a better way ?) > > If the objects you are calling are the same from one page to the next > you could try using an "or equals" > > so instead of always calling > @current_user = User.find session[:user_id]Instance variables (@current_user) don''t survive from request to request, so a lookup will be done for every request (in other words, from one page to the next). You could save these objects in your session and if you store sessions in memcached, things will speed up and no queries to the db will be needed. To speed up things, caching is a good thing. There are loads of tutorials about this and it caveats. -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
you''re right Wouter- that was dumb of me On Apr 20, 2:05 pm, Wouter de Bie <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Gavin Morrice wrote: > > You shouldn''t be making database calls from the view. > > If you''re making calls for the application layout then I''d add these > > to the application controller and call them with a before_filter > > (anyone know a better way ?) > > > If the objects you are calling are the same from one page to the next > > you could try using an "or equals" > > > so instead of always calling > > @current_user = User.find session[:user_id] > > Instance variables (@current_user) don''t survive from request to > request, so a lookup will be done for every request (in other words, > from one page to the next). You could save these objects in your session > and if you store sessions in memcached, things will speed up and no > queries to the db will be needed. > To speed up things, caching is a good thing. There are loads of > tutorials about this and it caveats. > -- > Posted viahttp://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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Gavin Morrice wrote:> You shouldn''t be making database calls from the view. > If you''re making calls for the application layout then I''d add these > to the application controller and call them with a before_filter > (anyone know a better way ?) > > If the objects you are calling are the same from one page to the next > you could try using an "or equals" > > so instead of always calling > @current_user = User.find session[:user_id] > > you could write @current_user ||= User.find session[:user_id] > > This should mean that the database call is only made if @current_user > is nil > > does that help? > > On Apr 20, 1:33?pm, Preethi Sivakumar <rails-mailing-l...@andreas-Thanks for your response. But, Am not making any db calls from view. I''ve helpers for everything which renders some tabs for user depending on his view. The queries for fetching the permissions that the person has and everything is fectched from db everytime the page is loaded even though that part of the layout is static once it is fectched for the first time. It gets refreshed everytime. That is the problem. i want only part of my page to be refreshed and other parts to remain static once loaded. How to achieve that? -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Apr 20, 2:37 pm, Preethi Sivakumar <rails-mailing-l...@andreas- s.net> wrote:> Thanks for your response. > But, Am not making any db calls from view. I''ve helpers for everything > which renders some tabs for user depending on his view. The queries for > fetching the permissions that the person has and everything is fectched > from db everytime the page is loaded even though that part of the layout > is static once it is fectched for the first time. It gets refreshed > everytime. That is the problem. i want only part of my page to be > refreshed and other parts to remain static once loaded. How to achieve > that? >You could either avoid traditional navigation and use ajax to update bits of the page as required or use fragment cacheing to cache the bits of html that are expensive to render or cache the data that sits behind that. Fred --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---