aneesh
-
Total Posts
:
2
-
Reward points
:
0
- Joined: Mar 24 '04
-
Status: offline
|
SQL Insert
Wed. Mar 24, '04 2:13 AM
( permalink)
i am using SQL Server 2000 as backend for ASP Application. i wanted to if the database will get locked if a table is used my many users at a time to insert records. or will it make any difference in the connection speed.?
|
|
|
|
Samuel
-
Total Posts
:
11785
-
Reward points
:
168350
- Joined: May 23 '01
-
Status: offline
|
RE: SQL Insert
Wed. Mar 24, '04 10:21 AM
( permalink)
lock contention issue is unavoidable if you really have huge amount of people trying to compete at the same time. However, our forum has a record of accepting more than 9500 posts a day without failure on a shared SQL server. It really depends on how powerful your machine is. You will have to choose a machine that is suitable for the size and the activity of your community.
ASPPlayground.NET ~ see our Version 4 plans here
|
|
|
|