Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nested Stored procedures... Efficent??

Status
Not open for further replies.
ranta

ranta

Programmer
Jun 24, 2003
30
Hi,

Are there any known efficency problems with calling a stored procdure from another stored procedure? I am currently doing this to collate the information I require for a report and it is taking 26 seconds to run. I don't believe there is enough data being sifted to account for this so I was wandering whether the nested SP call could be effecting it?

Thanks...

ranta
 
Status
Not open for further replies.

Similar threads

pabowen
  • Locked
  • Question
Accessing Nested JSON Array Data using OpenJSON
Replies
1
Views
570
jbenson001
jbenson001
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
282
pjw001
pjw001
raven4
  • Locked
  • Question
Nested IF Statement
Replies
7
Views
312
gmmastros
gmmastros
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
252
fredericofonseca
fredericofonseca
MacroAlan
  • Locked
  • Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
195
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top