----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ssv_2000 Message 4 in Discussion Hi vijrag, Thanks for ur comments. U had said - "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.". As I mentioned in my earlier post, I am told SQL Server caches the plan for a few recently executed SQL statements on the server. So, when the same update clause is sent to SQL over & over again, it wouldnt be compiling or working out the execution plan for the second time and hence wouldnt affect performance. Is that right? "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." Our transactions always span more than one record. The stored procedure is designed to handle update to only one table and one row at a time. So...even with use of Stored Procedures, our transactions are still maintained in the DAL object using ADO.Net's transcation object. Is it possible to send across a bunch of records to a Stored Procedure? "If you have your SQL embedded in your ASP it will become a Maintenace Nightmare" No. We have all our database SQL queries in the corresponding Data Layer Classes. The debate is between whehter the class should build its own Update, Insert, Delete Statement or call Stored Procedures. Thanks for ur time. SriVidya. ----------------------------------------------------------- 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]
