Query execution

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • manisharma0806
    New Member
    • Oct 2008
    • 1

    Query execution

    We are facing a problem while executing a query in our application :

    Its TIBCO businesswork application which invokes a Java component for processing of files. This Java applicaiton is based on the Spring xml xonfigurations. database connectiosn are maintained using spring transaction management.
    WE are facing this wierd problem. We execute number of queries to create cache.
    when it is fired using the application it's execution takes long time.
    But when we fire the same query at the same time using RAD(IDE) or putty , its executes really fast. We have seen there's no lock on the database.

    Can someone help us to debug the problem ?
Working...