https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 11:18:54 +0000 Fri, 05 Sep 2008 15:01:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1953 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/ms-sql-limits_topic1953_post6641.html#6641 Author: bigsapper
Subject: 1953
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.]]> Fri, 05 Sep 2008 15:01:53 +0000 https://forum.productcart.com/ms-sql-limits_topic1953_post6641.html#6641 https://forum.productcart.com/ms-sql-limits_topic1953_post6635.html#6635 Author: Hamish
Subject: 1953
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. :-) ]]> Thu, 04 Sep 2008 14:09:19 +0000 https://forum.productcart.com/ms-sql-limits_topic1953_post6635.html#6635 https://forum.productcart.com/ms-sql-limits_topic1953_post6633.html#6633 Author: JWL
Subject: 1953
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?
]]> Thu, 04 Sep 2008 12:30:45 +0000 https://forum.productcart.com/ms-sql-limits_topic1953_post6633.html#6633 https://forum.productcart.com/ms-sql-limits_topic1953_post6631.html#6631 Author: Hamish
Subject: 1953
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. 
]]> Thu, 04 Sep 2008 10:39:03 +0000 https://forum.productcart.com/ms-sql-limits_topic1953_post6631.html#6631 https://forum.productcart.com/ms-sql-limits_topic1953_post6619.html#6619 Author: JWL
Subject: 1953
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.
]]> Wed, 03 Sep 2008 16:38:28 +0000 https://forum.productcart.com/ms-sql-limits_topic1953_post6619.html#6619