Hi..
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:
* using simpleJdbcTemplate object
* plain statement object
* changing driver class from BasicDataSource to c3po in bean configuration.
But i cant able to reduce the response time to 2 seconds less atleast.
Please help which will be greatly appreciated...
Thank you.