• Post Reply Bookmark Topic Watch Topic
  • New Topic

increase the response time of a jsp page  RSS feed

 
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
Posts: 66258
151
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
Sheriff
Posts: 37384
531
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!