Multiple users accessing stored Proc at same time from ASP.net

Question

0.00/5 (No votes)

See more:

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

Posted 22-Apr-14 1:42am

Prashant Trambake

Add a Solution

Comments

Ankur^\m/ 22-Apr-14 7:48am

Each will have their own session. What exactly are you worried about? There are SQL locks that you can to lock a row when the data is being inserted.

[no name] 22-Apr-14 7:49am

How could we possibly tell you how to fix some random issue that has not even happened yet?

Bh@gyesh 22-Apr-14 8:06am

Use lock mechanism available in SQL. Refer following articles for locking
http://technet.microsoft.com/en-us/library/aa213039(v=sql.80).aspx
http://www.sswug.org/articlesection/default.aspx?TargetID=16921

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Telstra · Accepted Answer · 2014-04-22T02:29:00

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[^]

Multiple users accessing stored Proc at same time from ASP.net

1 solution

Solution 1

Add your solution here

Preview 0

Multiple users accessing stored Proc at same time from ASP.net

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us