Rahul Mahindrakar wrote:Hi
Some things I would look for
1) Precompile jsp ( for first time loading time)
2) put in some Timers in the jsp page and output them in the html to find out which part of the jsp takes time
3) Cache data retreived from the db so that the next time the db is not accessed anymore.
Br
Rahul P. Mahindrakar
I would not bother with 3 unless:
Your business logic can tolerate the cached dataYou know it is recovering data from the database that is to blame
Look for the obvious stuff first: what is causing the bottleneck? Is the CPU at 100%, or is it doing nothing and (probably) waiting for IO? Is your JVM running out of memory? If you run the same query in another client on the same machine, is it slow too? If you run the database locally is it much quicker? Do you return loads of results from your database? Do you need them all? Have you profiled the query in your database? Does it suggest any indices?
If nothing jumps out from that, I would profile your application itself, see if there are any hotspots.