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.