Using DAO Pattern to access data from database through JDBC . Sql query is taking too much time to execute and giving result .Basic steps of flow are ; 1. connect to database through data source lookup 2. get Resource Bundle 3. get query from resource bundle to execute. 4. Prepare Statement for the query. 5. Set Parameters in the prepare statement. 6. Execute query. What step could be the reason for delay in getting result. Is there any performance tunning tip for this scenario.
- Posted by: meenu arora
- Posted on: May 22 2007 06:18 EDT