This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JSP and the fly likes Improving response time Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Improving response time" Watch "Improving response time" New topic
Author

Improving response time

Bernard Sigmund Gustav
Ranch Hand

Joined: Dec 20, 2005
Posts: 170
Hello,

I have developed a web application.
Whenever I do queries though on past transactions and show certain transactions for a day, it gets slow. I know the pc being used not that fast but is there a way to improve its response time? I am using oracle 9i as its database and retrieving records from it gets slow. in a day, there are at least 1000 records.

i hope someone can help me with this and i would really appreciate the help.
Thanks
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41060
    
  43
Well, if the database is slow, then this is more of a DB problem than a JSP problem. Maybe more indexes would help speed up data access, or maybe Oracle chooses a bad execution plan. This is something to talk over with the DB administrator, and together look at the particulars of this problem.


Ping & DNS - my free Android networking tools app
Bernard Sigmund Gustav
Ranch Hand

Joined: Dec 20, 2005
Posts: 170
hi ulf,

thanks for the reply
i am not sure which area is making it slow. by area i mean the database or the code itself for retrieving the records. how can i tell?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41060
    
  43
Perform some timings:

- overall response time, i.e. from when the request hits the web server until the response is sent

- do the same for each DB query

Adding up all the DB time and subtracting it form the overall response time tells you how much time is spent in the web app. It's crude, but useful for a first approach. You'll also know which queries take a long time, and might be worthwhile analysing for performance gains.
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12759
    
    5
You might find the JAmon toolkit useful for monitoring your application performance.
Bill
Bernard Sigmund Gustav
Ranch Hand

Joined: Dec 20, 2005
Posts: 170
thanks ulf,
i do not know how to do the timings but i will try to find out though.

thanks also william. i will also take a look at jamon.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41060
    
  43
The simplest approach to timing would be something like this:
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Improving response time
 
Similar Threads
JSP page not loading completely..large data
Possible garbage collection issue
XML Validation
What happens when JVM is Restarted?
retrieving keys with a map interator