----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: vijrag Message 2 in Discussion Hi Srividya, As far as using the Stored Procedures what performance boost you get are as follows: If you have the sql statements embeded in your asp or client, then the DML Precompiler has to compile the sql script everytime, Optimize and arrive at the execution plan and then execute the query which degrades performance. If you have more than a few sql scripts which forms a transaction, then you have to maintain the transaction at asp level, in case of stored procedures, you can control the transaction at the sp level itself. This also reduces the no. of Round trips that is made btw db and ws. The SP's can also act as your Business Logic Layer but it is not a Best Practise, In case you have a Huge Project with Ntier architecture, you can have your BL in components, the Data Access Layer as SP. SP also help in Security, you can assign security rights at the SP levels. Lot more are there... vijrag ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
