|
 |
asp_database_setup thread: General Question - SQL v7 or 2000 vs Access 2000
Message #1 by "Mail List Management Account" <lists@m...> on Fri, 27 Jul 2001 06:02:26 -0400
|
|
In general terms, how many users can an Access 2000 Database reliably
serve at one time?
The same question except what about SQL v7 or 2000?
Thanks,
Bill
===================================
Jewelry, Gold & Pawn
1072 Adams Ave
Huntington, WV 25704
(xxx) xxx-xxxx
http://www.jewelrygoldpawn.com
===================================
Turnpike Ford
2480 5th Ave
Huntington, WV 25703
(xxx) xxx-xxxx
===================================
Custom Web Application Programming
Contact: was@i...
===================================
Message #2 by Joe Ingle <Joe@k...> on Fri, 27 Jul 2001 11:56:27 +0100
|
|
Hi Bill
Access, around a poultry 10
SQL 2000, 10,000+ concurrent users springs to mind, but it obviously, also,
depends on how you've designed your tables and queries.
SQL 7 not too sure, sorry!
Cheers
Joe
-----Original Message-----
From: Mail List Management Account [mailto:lists@m...]
Sent: Friday, July 27, 2001 11:02 AM
To: ASP Database Setup
Subject: [asp_database_setup] General Question - SQL v7 or 2000 vs
Access 2000
In general terms, how many users can an Access 2000 Database reliably
serve at one time?
The same question except what about SQL v7 or 2000?
Thanks,
Bill
===================================
Jewelry, Gold & Pawn
1072 Adams Ave
Huntington, WV 25704
(xxx) xxx-xxxx
http://www.jewelrygoldpawn.com
===================================
Turnpike Ford
2480 5th Ave
Huntington, WV 25703
(xxx) xxx-xxxx
===================================
Custom Web Application Programming
Contact: was@i...
===================================
Message #3 by "Daniel Walker" <danielw@w...> on Fri, 27 Jul 2001 11:33:37
|
|
> In general terms, how many users can an Access 2000 Database reliably
> serve at one time?
>
About two, as long as one of them's the website administrator, viewing
the site via loopback ;).
> The same question except what about SQL v7 or 2000?
>
Several thousand, if you build it right - let's say about one per dollar.
> Thanks,
>
> Bill
>
>
>
>
>
>
>
> ===================================
> Jewelry, Gold & Pawn
> 1072 Adams Ave
> Huntington, WV 25704
> (xxx) xxx-xxxx
> http://www.jewelrygoldpawn.com
> ===================================
> Turnpike Ford
> 2480 5th Ave
> Huntington, WV 25703
> (xxx) xxx-xxxx
> ===================================
> Custom Web Application Programming
> Contact: was@i...
> ===================================
>
>
Message #4 by "Thomas G. Ward" <tward@r...> on Fri, 27 Jul 2001 07:38:31 -0600
|
|
Bill, Both SQL Server and Access tout themselves as mutli-user databases
and they are. The problems that you run into with Access databases is that
they are intended for the desktop type applications where SQL Server is
intended for a much larger audience. Access (In my past experiences) has an
issue with table locking which would obviously cause problems in a
multi-user environment of 2 or more simultaneous users trying to access the
same table. SQL Server is extensive in its ability to service multiple users
(10000 or more). I would have to read the marketing literature on SQL
Server 2000 to be sure but I think that it goes down the cell level locking
where versions 6.5 and 7 were row level. ( Better check that last bit of
info though I'm not positive. Anyway, row and cell level locking enables
large numbers of users to access tables simultaneously. Hope this helps.
P.S. I am in love with SQL Server 2000. It is so easy to administer for a
beginner that it is almost pitiful. (Used SQL 6.5, 7.0, 2000 for 5 years)
-----Original Message-----
From: Mail List Management Account [mailto:lists@m...]
Sent: Friday, July 27, 2001 4:02 AM
To: ASP Database Setup
Subject: [asp_database_setup] General Question - SQL v7 or 2000 vs
Access 2000
In general terms, how many users can an Access 2000 Database reliably
serve at one time?
The same question except what about SQL v7 or 2000?
Thanks,
Bill
===================================
Jewelry, Gold & Pawn
1072 Adams Ave
Huntington, WV 25704
(xxx) xxx-xxxx
http://www.jewelrygoldpawn.com
===================================
Turnpike Ford
2480 5th Ave
Huntington, WV 25703
(xxx) xxx-xxxx
===================================
Custom Web Application Programming
Contact: was@i...
===================================
|
|
|
View Cart
