File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 41182
    
  45
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: 41182
    
  45
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: 12761
    
    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: 41182
    
  45
The simplest approach to timing would be something like this:
 
I agree. Here's the link: http://aspose.com/file-tools
 
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