Hi,

I am using hibernate with JPA. i have a oracle table having 5 columns and 50K rows on it. When i execute select tablename from tablename t , it takes 7 mins to execute the query and return list. no joins nothing, its simple select query. can anyone tell me how to reduce execution time ?

your help is highly appreciated.

thanks & regards
Siva

How long does it take to execute the query on the database itself? Also are there any network issues to connect to the database from the app?

thanks for the reply latha,

When i run the query in database it takes 45 seconds. i don know there is any network issue. hw to check is there network issue ?

Putting some pertinent indexes on that table might be extremely helpful. Get your db admin to do it.

to check the network speed, just hit a dummy or dual table with no records. in your app log the timestamp before hitting the database and after hitting the database.
-Srilatha.

Hi ,

I did check the query response time. Response time is less than a second. ( Just i executed select sysdate from dual ). But when i execute this query and debug through eclipse



It takes 9 mins.

When i run the same query using toad or dbartisan, it takes 1:17 mins, this table contains around 91680 records.

Usually how much time hibernate takes to construct Entity for all these records. hw to check.... any idea to reduce the time.

thanks in advance.