I have a jsp which has to display result of 35 queries in tabular form. The table consists of 3 colomns. All these 35 queries are written in hibernate using createSQLQuery(). Result of each query is a single record. I am directly calling the DAO class that executes these 35 queries in jsp. The jsp is taking lot of time to load. When I have placed timers in DAO, I noticed that the first column in jsp is taking longer time. But the remaining 2 colums are taking very less time.
I know we are not supposed to use Hibernate directly in jsps but as our applications is an old one things had to be done this way. This cannot be avoided.
The page is taking on an average 20,000ms to load. Which is very bad.
|