----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mrinal Message 2 in Discussion Hi , Well Using Stored Procedure do boost the performance upto a very great extent , which depends on certain factors Like Amount Of Business Logic that Needs To Be Incorporated In a Procedure , but still consider following things : 1. Dynamically built statement will be Re - formed Every Time In Ur code and Passed On to the Sql Server , where As Ur Procedure Will be Compiled At Database Server . 2. I/O is a resource Intensive Operation Which Will be More In Case of Passing a Dynamic Sql , It's Always Good To Pass Parameters For Stored Procs At Run Time . 3. Complex Business Logic are easily implementatble through Procedures , even u can use something like Temporary tables , Table variables to boost the performance . Well In case u work on a Big Project , and try both the things then u can asceratin the correct Performance difference Between the two , Regards , Mrinal ----------------------------------------------------------- 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]
