Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JSP and DB Connection  RSS feed

 
Karthik Kannan
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I developed a web application that has only jsps and some supporting java classes.

jsps deal with displaying charts (jfreechart) based on data from the DB. Each jsp opens a connection and creates a chart. There are only 3 jsps which are of the above mentioned type.

the application is working fine in my system.

when it is launched in a public ip, the application becomes very slow.

Can anybody tell me why this performance problem arises? is it due to DB operation or IO operation
Tell me ways to solve it. :roll:

Thanks in advance.

Regards,
Karthik K.
 
Warren Dew
blacksmith
Ranch Hand
Posts: 1332
2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Possibly the charts are bandwidth intensive, resulting in slow operation unless one has a very fast network connection?
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to monitor your code to see where it is performing slowly. For example if you monitor all database access then you should be able to tell if there is a performance difference if you are making calls or your customers are.

Using my open source jamon code with a servlet filter (the filter is available in a demo WAR you can download), and by monitoring your jdbc code you should have a good idea where the problem is. The servlet filter can be incorporated without changing your code - simply change your web.xml, compile the JAMonFilter.java class and include JAMon.jar in your war.
[ March 27, 2005: Message edited by: steve souza ]
 
Heonkoo Lee
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just breaking in to say hello to Steve. I found your JAMon while searching some free monitoring tools, and have been using it for several months. It is so convenient and easy to use. Whenever I need to monitor executing time, I use it. I just wanted to thank Steve for the neat tool.

Regards,
[ April 03, 2005: Message edited by: Heonkoo Lee ]
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Heonkoo Lee:
Just breaking in to say hello to Steve. I found your JAMon while searching some free monitoring tools, and have been using it for several months. It is so convenient and easy to use. Whenever I need to monitor executing time, I use it. I just wanted to thank Steve for the neat tool.

Regards,


Thanks, for the kind words. It is the best and only payment open source developers get.
[ April 05, 2005: Message edited by: steve souza ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!