Improving application Performace

[Sahil Sharma]

Hi,

I need some help in order to choose the best approach for the performace of my website.
Currently we display menus and its corressponding sub-menus on the Page.Logic which we have implemented right now is: whenever user clicks on the main menu, we go to the Database and retrieves its corresponding sub-menus. This is done for each click on the the main menu or parent menu.Now, I would love to know what would be the better approach, per the performance is concerned, keep doing the same thing or bring the entire menu and its submenu when user logs in and place it in session scope.

Thnx

[Jesper de Jong]

What do you think yourself... ?

Ofcourse it will be faster if you just get it from the database once and cache it in memory.

[David O'Meara]

You can even cache just the drop-down using oscache

[Sirish Kumar Gongal Reddy]

Hi Sahil Sharma,
As per my knowledge the good design is to maintain our application with limited no.of connection objects,to maintain the connection object on the heap is very expensive right ?
As per your application the intaraction with the database is more it improves the network traffic,it's consumes one connection per each time to intaract wiht the database.
My suggetion is reduse the contacts wiht the database that give you good efficiency on your application.
Regards,
G Sirish Reddy.,

[Ilja Preuss]

Moving to Performance forum...

[srinivas kalluri]

Hi,
When you are getting the submenus data for the first time from the database cache the data in the session object, and use the cached data when you need it for the next time. This would reduce the database interactions each time you click the menu to get the submenu.