多个用户同时从ASP.net访问存储过程 [英] Multiple users accessing stored Proc at same time from ASP.net

问题描述

您好，



我正在开发一个应用程序，其中有很多用户在一个页面上。在我的申请中可能会发生100人同时下订单。在数据库中下订单我已经使用了存储过程SP_NewOrders。



如果100人点击下订单按钮会发生什么。如何同时访问这100个请求SP_NewOrders。我的proc也在做一些计算。



如果有任何问题，我该如何解决？







谢谢你

解决方案

你可以在你的商店程序中使用锁。

有关锁定的更多信息，请参阅



http://www.sqlteam.com/article/introduction-to-locking-in-sql-server [ ^ ]



http://technet.microsoft.com/en-us/library/ms175519（v = SQL.105）的.aspx [< a href =http://technet.microsoft.com/en-us/library/ms175519(v=sql.105).aspxtarget =_ blanktitle =New Window> ^ ] < br $> b $ b

http://technet.microsoft.com/en-us/library/aa213039（v = sql.80）的.aspx [<一个href =http://technet.microsoft.com/en-us/library/aa213039(v=sql.80).aspx\"target =_ blanktitle =New Window> ^ ]

Hello,

I am developing an application in which so many users are on one page. in my application may happen that 100 people are placing an order at same time. to place order in database I have used a stored procedure SP_NewOrders.

What will happen if 100 people hit "Place Order" button. How the "SP_NewOrders" will be accessed by those 100 request simultaneously. My proc is also doing some calculations in it.

If any issue, how can I fix it?



Thank you

解决方案

You can use locks in your store procedure.
For more info on lock please refer

http://www.sqlteam.com/article/introduction-to-locking-in-sql-server[^]

http://technet.microsoft.com/en-us/library/ms175519(v=sql.105).aspx[^]

http://technet.microsoft.com/en-us/library/aa213039(v=sql.80).aspx[^]

这篇关于多个用户同时从ASP.net访问存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！