Query execution

Help | Site Map

online: users | - - 164 experts

Forums
- Programming Languages
  
  C / C++ Java .NET Visual Basic Python
- Web Development
  
  PHP Ruby / Rails Perl ASP Coldfusion Javascript / Ajax Flash / Actionscript XML HTML / CSS
- Database
  
  MySQL Oracle SQL Server PostgreSQL Access DB2
- System Administration
  
  Apache IIS Networking Linux / Unix / BSD Windows
- More
  
  Software Development Mobile Development Misc Questions
Howtos
- Browse all Howtos and articles here
Jobs
- Browse All Jobs
- Post Job Listing

bytes > answers > DB2

LinkBack

Thread Tools

October 10th, 2008, 08:08 PM

manisharma0806 manisharma0806 is offline

Newbie

Join Date: Oct 2008

Posts: 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 ?

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are Off [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.

Post your question now . . .
It's fast and it's free

What is Bytes?

Popular Articles