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
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
Joined: Dec 20, 2005
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?
Joined: Mar 22, 2005
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.