MS SQL Limits?
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=1953
Printed Date: 26-November-2024 at 6:00pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: MS SQL Limits?
Posted By: JWL
Subject: MS SQL Limits?
Date 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. |
Replies:
Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: JWL
Date 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? |
Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: bigsapper
Date 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. ------------- http://militarysignatures.com"> 
|