Bad Execution?

• sqlSushi

  Mr or Mrs. 500

  Points: 516

  More actions

  January 15, 2004 at 4:25 pm

  #59571

  Hello all,

   

  We have a proc that when executed from from QA is efficient and fast.

  When the proc is hit from a web page the performance of the proc while seen in Profiler is god awful.  We throw in WITH RECOMPILE and it simmers down again.

  Any explanation of why this can occur?

   

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736544

  More actions

  January 15, 2004 at 4:47 pm

  #490329

  What does the proc do? How is the web server connecting?