How to program a multi-user app
Hi,
I am writing a web application with ASP and SQL Server 2000. The app basically enables the manipulation of data in the database. When I open a recordset, I do so with pessimistic locking.
Scenario:
Two people, A and B, are using my app at the same time. A opens a record, and therefore B is barred from opening it.
However, while A has the record open, B goes (in his browser) to the page that requests the opening of the record.
Question:
What happens to B's request? Is it discarded (and lost) by the server, or does the server queue it and execute it when A releases the record? If queueing takes place, how many requests can wait in a queue?
I am new to the way in which multi-user apps ought to be programmed, and this is an area I don't understand. Please can you help me see how this works, and if I need to apply special techniques for catering for multiple users?
Thanks.
James
//##
|