I am using spring jdbctemplate to fetch the records from oracle database.
But it is taking too long time to execute a simple select query. The query which is having 400 records is taking around 12 to 15 seconds. I am using json to retrieve that data.
But if i execute same query in toad, response time is less than 1 second. I am using java jdbcTemplate.query(sql, params, RowMapper object) and each record will have only 4 values.
I tried in following ways:
But i cant able to reduce the response time to 2 seconds less atleast.
Please help which will be greatly appreciated...
Try to create indexes on your tables. I think your database table does not contains required indexes.
Thanks for your reply. It resolved now. Because database and application are different servers.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.