Results 1 to 2 of 2

Thread: SpringJdbcTemplate taking long time to execute query

  1. Dec 13th, 2011, 04:36 AM #1
    arunpatil
    arunpatil is offline Junior Member
    Join Date
    Nov 2011
    Posts
    6

    Default SpringJdbcTemplate taking long time to execute query

    Hi All,

    I am executing one query through SpringJdbcTemplate which gets me result in approx. 11 mins.

    But same query gives me result in 3-4 secs. in Toad.

    The time difference is quite huge in both the cases.

    Can someone please help me on this?
    Reply With Quote Reply With Quote
  2. Dec 13th, 2011, 05:41 AM #2
    Marten Deinum
    Marten Deinum is offline Senior Member
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    13,629

    Default

    Post code... Also is the query slow or parsing the results... If you are turning 400000 results into objects with a row mapper that is going to take some time... So make sure you are comparing the same things and not apples and oranges...
    Marten Deinum
    Java Consultant / Pragmatist / Open Source Enthousiast / Author

    Pro Spring MVC: With Web Flow
    Conspect

    Have you read the reference guide.
    Use the [ code ] tags, young padawan
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules