Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

increase the response time of a jsp page

 
mihir maniar
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i use model 1 architecture and when i retrieve 100 records from a database then the response time of the page is somewhere round 5 sec. i want it faster so that i can improve the site performance. pleasse guide me . thank you.
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
are using connection pooling or getting the connection at the time of query? or you may need to tune your code a bit.

But prior to all you should watch your database stuff. like, use indexes etc.

Dont know if your are having some heavy image or some other heavy stuff on your page.
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by mihir maniar

i do not have any heavy images and i am not using indexes or stuff. i am not using connection pooling .will u please guide me on indexing and connection pooling. thank you


I dont know, I should have done this or not. I just reposted the mihir's post. I am very sorry if I dont have these kind of privileges.
Thanks.

Mihir, here we have more folks to help you out.
Thanks.
[ October 21, 2004: Message edited by: adeel ansari ]
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65339
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mihir,
Consider the columns in your where clause and add those to an index. What database are you using? Some come with suggestions on creating indexes.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic