Announcement Announcement Module
Collapse
No announcement yet.
JDBCTemplate Performance issue Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • JDBCTemplate Performance issue

    Hi,
    I am using Spring's JDBCTemplate to interact with database. We are going through performance tuning phase of our project. We are having few queries if we run them directly on SQLplus there retreival time is 1 sec. But when we run the same query through our application its taking about 6 secs to fetch record(I have put timestamp before and after execute method of template).
    Transaction attribute we have set is PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED
    Web Server WebSphere 5.1.2
    Database Oracle 8i
    Could anybody suggest some way to improve performance.

    Thanks in advance

  • #2
    If you don't execute updates you might add the transaction attribute "readOnly".

    Regards,
    Andreas

    Comment

    Working...
    X