Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Improving application Performace

 
Sahil Sharma
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Java Cowboy
Saloon Keeper
Posts: 15272
37
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can even cache just the drop-down using oscache
 
Sirish Kumar Gongal Reddy
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to Performance forum...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic