Improving response time

[Bernard Sigmund Gustav]

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]

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.

[Bernard Sigmund Gustav]

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]

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]

You might find the JAmon toolkit useful for monitoring your application performance.
Bill

[Bernard Sigmund Gustav]

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]

The simplest approach to timing would be something like this:

long start = System.currentTimeMillis();
 
callLongRunningDatabaseQueryHere();
 
long elapsedTime = System.currentTimeMillis() - start;