Application.html.erb problem

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 :slight_smile:

Gavin M. 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.

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 S. <rails-mailing-l…@andreas-

you’re right Wouter- that was dumb of me

On Apr 20, 2:05 pm, Wouter de Bie [email protected]

Gavin M. 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 S. <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?

On Apr 20, 2:37 pm, Preethi S. <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