Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > db2 > answers

Stored Procedure - Help Needed

Newbie
  
Join Date: Nov 2007
Posts: 1
#1: Nov 1 '07
Hi,

I've a stored Procedure, it fetches data from a temp table
Using that data it queries the DB using a single select statement
then it inserts into DB

But the peroformance is very poor
I'm using IBM db2

please give ur suggestions to improve the performance

RedSon's Avatar
Site Moderator
  
Join Date: Jan 2007
Location: America
Posts: 3,393
#2: Nov 1 '07

re: Stored Procedure - Help Needed

Quote:

Originally Posted by javasimhan

Hi,

I've a stored Procedure, it fetches data from a temp table
Using that data it queries the DB using a single select statement
then it inserts into DB

But the peroformance is very poor
I'm using IBM db2

please give ur suggestions to improve the performance

Next time, try posting to the DB2 forum.
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

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 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved