MS SQL Limits?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I read that MS Access has limits to the amount of simultaneous users i.e. 256 and only 1 edit at a time to the database.

What are the MS SQL numbers in comparison?  Are there limits?  How many edits can be made at a time?

Thanks.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Topic: MS SQL Limits? Posted: 03-September-2008 at 4:38pm
	I read that MS Access has limits to the amount of simultaneous users i.e. 256 and only 1 edit at a time to the database. What are the MS SQL numbers in comparison? Are there limits? How many edits can be made at a time? Thanks.

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 04-September-2008 at 10:39am
	Hi, I don't know the numbers, or even if there are any specific numbers. MS SQL scales well and has locking available down to record level. ProductCart is used on some high volume websites successfully.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Posted: 04-September-2008 at 12:30pm
	Hi Hamish, glad you replied - you seem like a very knowledgeable person on these forums. So, MS Access is limited to one edit on the database at a time or something like this, does MS SQL have a limit in this capacity? Or how many edits can be made at once? You mentioned locking and I think that is related to this issue of concurrent users. So, ideally - how many users can you have updating the database at one time - and is there a way to adjust settings for locking and such?

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 04-September-2008 at 2:09pm
	Hi, I'm no DB expert - in any sense of the word. However, if you consider that MS SQL DB's are used in very large organisations on their LAN's then coping with transactions on a website will, unless you become an ebay or similar, not be an issue. I took a look at the wikipedia site regarding ms sql and it talks about being able to adjust the locking, but I've no idea how it's done. I really doubt it will be an issue and if it does become one then your site will be successful enough that you can easily justify paying a pro DBA to take a look. :-)
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

bigsapper Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 30-July-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigsapper Report Post Thanks(0) Quote Reply Posted: 05-September-2008 at 3:01pm
	There is essentially no limit for SQL Server. It's governed by the user license. If you have a hosting solution that uses SQL Server, the licensing issues are the domain of the hosting company.