Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB connection in webapplication.

 
raju sangam
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am working on webapplication which is developed using Servlets,jsp and some simple java classes.
This application needs to interact with multiple databases ( few databases from another server machine), and all JDBC stuff done in one java class and that class is using accessed in servlets.
Though its working well but it takes lot of time to run from page to page.

please give feasable solution to improve the performance.
(Alternate way to access the database)

Thanks,
Sangam
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Um, write better SQL? If it is taking a long time look at where the bottle necks are. Look at whta you are doing to help the user and see if you really need to display all of that data or if there is another way to do it.

Eric
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC.

Eric
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic