Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-05 : 12:39:16
|
Bill Tan writes "When multiple internet users are using the same web page to access the same table, will SQL Server service each request sequentially or will the SQL Server service the requests using multithreading strategy? Note that the SQL request is the same, but update, insert, delete data that belongs to them. Therefore, there is no locking of data possibility here. Table locking is not possible too, because we do row level locking.
The internet users may be clicking image icons on the webpage which caters save, delete, new records, at different point of time. But, when the database request reaches the server, the SQL service request may reach at the same time, or at an overlapping time frame. I would prefer to be more comfortable, to know the database behavior, so that better SQL statements can be used and used with meaningful objectives in mind. Sorry, I may be barking up the wrong tree, it was just a sudden question can besieged my thinking while doing internet architecture design" |
|
|
|
|
|
|
|
SQL Server behavior when serving possible concurrent SQL requests on the same table