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.
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.,
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
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.