[Ordering] Advantages and Disadvantages in Packaging Application Logic using stored procedure [Repost]

xiaoxiao2021-03-06  52

http://blog.joycode.com/ghj/archive/2004/08/26/31693.aspx

SQL Server 2005 can write a stored procedure with .NET language, in small and medium applications, use stored procedure package application logic to a nice choice.

The advantages of using the stored procedure package application logic are as follows:

1. DBA Developer division is clear. Code between code modular. Reduce the database operator and programmer's error. 2, database security; you can set the connection string account only access to the stored procedure, uninterrupted. Such data integrity is also guaranteed. 3, the stored procedure is compiled, the execution is fast. 4, the level of the transaction, the stored procedure level transaction, ADO.NET level transaction comparison. consistency. 5, reduce network traffic. A manner that requires a few rows of Transact-SQL code can be implemented by a separate statement of a procedure code without the need to send a digital line code in the network.

The disadvantage of using the stored procedure package application logic is as follows: 1, the programming language SQL function is poor (excluding SQL 2005) 2, is not enough integration with the programming environment (excluding SQL 2005) 3, portability (different databases) 4, database server pressure Big

It is like the current version of the 9CBS Forum, which is encapsulated during the stored procedure. A more distressed feeling is that the database server is too large. The cost of purchasing higher performance database server is too large. To this end, in the next generation of technical community architecture design, the application logic layer is specifically independently. In the stored procedure here, some adjustments will be made. No longer completely used stored procedure package application logic.

At present, the configuration of the 9CBS forum database server is as follows: Intel (r) Xeon (TM) CPU 2.80GHz * 2 (Double to strong 2.8G) 2G memory dual-channel motherboard SCSI 15000 turn hard disk 4 made RAID 5WIN2003 operating system

The activities of Beijing .Net Group this evening, I will introduce the current architecture of the 9CBS technology community and the selection of the next-generation technology community architecture, which is talking about the storage process package application logic. Interested in seeing Beijing .NET GROUP website, welcome to participate. Beijing .NET GROUP website: http://www.mscommunity.com/usergroup/

In fact, this issue is very common, many places can be seen, such as 9CBS below:

Http://search.9cbs.net/expert/topic/2437/2437130.xmlhttp://search.9cbs.net/expert/topic/2201/2201278.xmlhttp://search.9cbs.net/expert/topic/ 1980 / 1980958.xml

转载请注明原文地址:https://www.9cbs.com/read-117553.html

New Post(0)