Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Spring Spring JdbcTemplate and ResultSet is too slow..

Have Programming Question? Ask it here!
 
 
 


Praveen
Spring JdbcTemplate and ResultSet is too slow..
2 Answer(s)      3 years and 7 months ago
Posted in : Spring


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.


Advertisement
View Answers

December 31, 2010 at 6:42 PM


Hi,

Try to create indexes on your tables. I think your database table does not contains required indexes.

Thanks



January 7, 2011 at 6:48 PM


Thanks for your reply. It resolved now. Because database and application are different servers.



Related Tutorials/Questions & Answers:
Spring JdbcTemplate and ResultSet is too slow..
Spring JdbcTemplate and ResultSet is too slow..  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
What is Spring's JdbcTemplate ?
What is Spring's JdbcTemplate ?  Hi, What is Spring's JdbcTemplate ? Thanks
Advertisements
ResultSet
ResultSet   What is a ResultSet
ResultSet
ResultSet  What is a ResultSet
ResultSet
ResultSet  I want to retrieve data of unknown datatype from database.how to do it using resultset or Resultsetmetadata.Can you please tell me what... = con.createStatement(); ResultSet rs = st.executeQuery
JDBCTemplate BatchUpdate() example not working
JDBCTemplate BatchUpdate() example not working  Hi, I tried the JDBCTemplate BatchUpdate example, with IBM DB2 database. I updated the dataSource bean values accordingly. When I try, the program runs fine, however the database
jdbctemplate select query
Spring 'jdbctemplate' insert example The 'JdbcTemplate' class is the core class in Spring JDBC core package. This class is responsible... procedure calls, perform iteration over ResultSet & fetching of returned parameter
jdbctemplate batchUpdate example
jdbctemplate batchUpdate example The performance of JDBC driver improves.... This Section contains the example of batch update using 'jdbcTemplate'. Two... batchUpdate { private JdbcTemplate jdbcTemplate; public void setDataSource
Spring Batch Example
about  batchUpdate()  method of class JdbcTemplate in Spring framework... Spring Batch Example      ...://www.springframework.org/schema/beans/spring-beans-2.0.xsd http
multiple resultset in one resultset
multiple resultset in one resultset  how to retrive multiple resultsets in one resultset in java.? plz help
SQL function extremely slow from 5.5
SQL function extremely slow from 5.5  SQL function extremely slow from 5.5
resultset metadta
resultset metadta  import java.sql.Connection; import... Employee Details Using resultset metadata: "); Connection con = null...(); ResultSet rs = st.executeQuery("SELECT * FROM employee
Why Dose Hibernate Run Very Slow?
Why Dose Hibernate Run Very Slow?  I use Hibernate in netbean 6.9.1, when I run by F6 of netbean, Hibernate run very slow, it run some row INFO.... in GlassFish of netbean, web of me run very slow. I have configure Hibernate
Update a resultset programmatically
Update a resultset programmatically  How to update a resultset programmatically
The cursor in scrollable resultset
The cursor in scrollable resultset   How to move the cursor in scrollable resultset
function error too many input arguments
function error too many input arguments  function error too many input arguments
spring
spring   hi how can we make spring bean as prototype how can we load applicationcontext in spring what is dependency injection
spring
spring  Access JSP files in Spring
spring
spring  javascript browse image in spring progrme
spring
spring  how to upgrade from struts2 to spring
spring
spring  sir how to access multiple jsp's in spring
Resultset - JSP-Servlet
Resultset  I am writing while(rs.next){} but if resultset is null then it cannot enter in while block. I want,if resultset is null then it will enter into the while block.  Hi friend, A ResultSet object
spring
spring   i am a beginner in java.. but i have to learn spring framework.. i know the core java concepts with some J2EE knowledge..can i learn spring without knowing anything about struts
SQL exception, Exhausted ResultSet
SQL exception, Exhausted ResultSet  javax.servlet.ServletException: java.sql.SQLException: Exhausted Resultset iam getting this error messege whenever i run my code. what would be the possible reasons
Spring
Spring  What is AOP concept in spring? How AOP concept differ from DI concept
spring
spring  sir can you explain me the flow of sample example by using spring? thanks
resultset problem - JSP-Servlet
resultset problem  hi I have one problem with resultset? ResultSet rs=st.execute("select subjname,staffname from staffdetails"); while... is java.sql.SQLException: Operation not allowed after ResultSet closed how
JTable populate with resultset.
JTable populate with resultset.  How to diplay data of resultset...) JTable(Vector data, Vector columneNames) Here is a JTable populate with resultset...(); ResultSet resultSet = statement.executeQuery(sql
Resultset Issue in SQL
Resultset Issue in SQL  when i call rs.next() in my code it is returning false, though im having valid query to execute and fetch a row from database.how can i resolve this issue. My code is: SELECT JOBDESCRIPTION,CATEGORY
Resultset with one to many relationship
Resultset with one to many relationship   Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D... populate my bean classes from resultset without using hibernate, so
large resultset values - SQL
large resultset values  i have one query which will bring more than one lakh records from database(total records are abt 3 crores). While getting the details i'm getting error like
JSP - Resultset - JSP-Servlet
JSP - Resultset  hello sir, how can i count record in jsp. i use resultset in my jsp so in my login form how can i check the username and password is correct or not...?? please reply it's urgent.. thanks
spring
spring   package bean; public interface AccountsDAOI{ double... normally. i set the classpath=D:\java softwares\ST-IV\Spring\spring-framework-2 .5.1\dist\spring.jar;D:\java softwares\ST-IV\Spring\spring-framework-2.5.1\lib\c
Spring
the following links: http://www.roseindia.net/spring/ http://www.roseindia.net/spring
Spring
the following links: http://www.roseindia.net/spring/ http://www.roseindia.net/spring/bean-init.shtml http://www.roseindia.net/spring/spring3/spring-3-hello
Spring
Spring  I understand spring as dependency injection. It can avoid object creating and can directly inject values. But i am comfusing that Dependency... are created. By the same way i want to know how spring injected property
ResultSet In Java
ResultSet In Java In this section we will learn about the ResultSet in Java... that are mostly used in to get the value. ResultSet contains the data of a table after executing the SQL queries. Object of ResultSet also maintains the current position
How do i slow down the game (othello game)??
How do i slow down the game (othello game)??  Hello, I built an othello game that can be played by 2 humans , human and computer and two computers. Everything works correctly but the problem is that when 2 computers play
spring - Spring
spring  what is Session Factory in spring
spring - Spring
spring  what is the use of HashTable concept in spring
receive a ResultSet from a stored procedure
receive a ResultSet from a stored procedure  How do I receive a ResultSet from a stored procedure
JDBC ResultSet first() Example
JDBC ResultSet first() Example: The ResultSet first() are use to moves the cursor to the first row in the ResultSet object. It return true if the cursor pointed first row in the ResultSet and return false if the ResultSet object does
JDBC ResultSet last() Example
JDBC ResultSet last() Example: The ResultSet last() are use to moves the cursor to the last row in the ResultSet object. It return true if the cursor pointed last row in the ResultSet and return false if the ResultSet object does
spring - Spring
spring  give me the explanation about spring>and give me the difference between spring and EJB 3.0 WHAT IS THE USAGE OF SPRING WHERE WE HAVE TO USE IT? GIVE ME ONE EXAMPLE
ResultSet object initialization - Java Beginners
ResultSet object initialization  How to initialize resultset object  Hi friend, public interface ResultSet A ResultSet object maintains a cursor pointing to its current row of data. A default ResultSet object
spring - Spring
spring  Hi sir how compile spring application on jboss5.1.0 server how run spring application on jboss5.1.0 server thanks
spring - Spring
spring  what is the use of spring  Hi Friend, Spring is grate framework for development of Enterprise grade applications. Spring.... Spring can be used to configure declarative transaction management, remote access
SPRING - Spring
SPRING  In spring frame work when applicationcontext.xml will be load into the contianer i want answer plz replyyyyyy
spring - Spring
spring  how spring is light weight? please tell me this i want to know
spring - Spring
spring   hi, I need sample example user update profile using spring with hibernate and spring jsp. I need the sample code very urgently. Please... the following link: http://www.roseindia.net/struts/hibernate-spring/index.shtml
 

 

 

DMCA.com