That's correct. Dynamic SQL is generally slower than Stored procs.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Stuart Davies
[mailto:mssqldba-ezmlmshield-x44688330.[Email address protected]
Sent: Wednesday, June 29, 2005 7:56 AM
To: LazyDBA Discussion
Subject: Performance issue - am I correct

I have recently "inherited" a database from another part of the business
and have been tasked with re-writing it.
In several places, DTS packages use VB executables for fairly straight
forwards SQL statements.

My main concern is that of Performance . I have tried running the code
from the .exe and QA on the only data I have - roughly a tenth of the
usual load and there appears to be an adverse impact when running the
.exe

Am I correct that an executable will have poorer performance over the
same code run via a stored procedure?

Thanks in advance

Stuart



****************************************************************************
*******
The contents of this email are confidential to the intended recipient.
It may not be disclosed to or used by anyone other than the addressee, nor
may it be copied in any way. If received in error, please contact the
company on 01793-715380, then delete it from your system. Please note
neither the company nor the sender accepts any responsibility for viruses
and it is your responsibility to scan attachments (if any) for viruses.
No contract may be concluded on behalf of the company by means of email
communications.

www.boxclever.co.uk
****************************************************************************
*******


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and delete
the material from any computer.


MS Sql Server LazyDBA home page