473,721 Members | 1,813 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can you have 50 simultaneous web users with a MSDE, ASP.NET/ADO.NET backend...?

Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net
worker process", therefore doesn't that mean that even 50 simultaneous human
users of the website would appear to the database backend as a single user.
Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database
backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous
change to make while NOT limiting the number of simultaneous web users in
any way?
Nov 19 '05 #1
12 2311
You got it...

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Dan V." <da**@yah.com > wrote in message news:uX******** ******@TK2MSFTN GP15.phx.gbl...
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net
worker process", therefore doesn't that mean that even 50 simultaneous human
users of the website would appear to the database backend as a single user.
Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database
backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous
change to make while NOT limiting the number of simultaneous web users in
any way?

Nov 19 '05 #2
Dan V. wrote:
Since an ASP.NET/ADO.NET website is run on the server by a single
"asp_net worker process", therefore doesn't that mean that even 50
simultaneous human users of the website would appear to the database
backend as a single user.
No. Multiple connections will be made. Yes, they will be made by the same
user, but that does not decrease the number of connections made. Each
connection contains its own session.
Therefore, wouldn't switching our Access
(actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET
website to an MSDE backend be an advantageous change to make while
NOT limiting the number of simultaneous web users in any way?


I don't follow you. In your first statement, you seem to be arguing (albeit
based on a flawed premise) in favor of retaining your Access backend ...
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Nov 19 '05 #3
I understood his post as requesting confirmation for his impression
that replacing his Access database with an MSDE database would
increase his his website's capacity to serve customers, since MSDE
doesn't choke on 50 simultaneous connections while Access might.

I agree with that.

Whether it's 50 simultaneous users each requesting a connection,
or one user requesting 50 connections is immaterial to the end result :

At some point, Access will choke while MSDE will continue to chug along.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Dan V. wrote:
Since an ASP.NET/ADO.NET website is run on the server by a single
"asp_net worker process", therefore doesn't that mean that even 50
simultaneous human users of the website would appear to the database
backend as a single user.


No. Multiple connections will be made. Yes, they will be made by the same
user, but that does not decrease the number of connections made. Each
connection contains its own session.
Therefore, wouldn't switching our Access
(actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET
website to an MSDE backend be an advantageous change to make while
NOT limiting the number of simultaneous web users in any way?


I don't follow you. In your first statement, you seem to be arguing (albeit
based on a flawed premise) in favor of retaining your Access backend ...
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET

Nov 19 '05 #4
I am saying we would switch to MSDE if it was faster - I thought it was
clear... :)
Therefore, wouldn't switching our Access
(actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET
website to an MSDE backend be an advantageous change to make while
NOT limiting the number of simultaneous web users in any way?


"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Dan V. wrote:
Since an ASP.NET/ADO.NET website is run on the server by a single
"asp_net worker process", therefore doesn't that mean that even 50
simultaneous human users of the website would appear to the database
backend as a single user.
No. Multiple connections will be made. Yes, they will be made by the same
user, but that does not decrease the number of connections made. Each
connection contains its own session.
Therefore, wouldn't switching our Access
(actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET
website to an MSDE backend be an advantageous change to make while
NOT limiting the number of simultaneous web users in any way?


I don't follow you. In your first statement, you seem to be arguing

(albeit based on a flawed premise) in favor of retaining your Access backend ...
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Nov 19 '05 #5
Juan T. Llibre wrote:
I understood his post as requesting confirmation for his impression
that replacing his Access database with an MSDE database would
increase his his website's capacity to serve customers, since MSDE
doesn't choke on 50 simultaneous connections while Access might.

I agree with that.

Same here - while I have read about an application where careful coding and
connection-handling allowed Access to adequately handle 200 users, MSDE
would probably have done the job better.
Whether it's 50 simultaneous users each requesting a connection,
or one user requesting 50 connections is immaterial to the end result
:

At some point, Access will choke while MSDE will continue to chug
along.


Again, careful connection-handling might allow Access to chug along as well
as MSDE. Don't forget about the thread-governor in MSDE ...

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Nov 19 '05 #6
I know, but the first sentence muddied the waters ...

I agree that MSDE should be used. Again, while it is possible to manage your
connections so that Access will perform well under this user load, MSDE will
be more forgiving if you get sloppy ... with Access, one connection left
open too long will bring things to a screeching halt. You have to do things
exactly right to make Access work well in these copnditions, as well as
making the proper sacrifices (virgin calves only) ... ;-)

Bob

Dan V. wrote:
I am saying we would switch to MSDE if it was faster - I thought it
was clear... :)
Therefore, wouldn't switching our Access
(actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET
website to an MSDE backend be an advantageous change to make while
NOT limiting the number of simultaneous web users in any way?


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Nov 19 '05 #7
On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:

¤ Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net
¤ worker process", therefore doesn't that mean that even 50 simultaneous human
¤ users of the website would appear to the database backend as a single user.
¤ Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database
¤ backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous
¤ change to make while NOT limiting the number of simultaneous web users in
¤ any way?
¤

As Bob mentioned in one of his posts you may want to keep in mind the that MSDE has a Workload
Governor that will throttle connections when there are more than eight concurrent operations. This
could perceptibly affect performance when using MSDE.
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #8
Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition
and MSDE 2000 allow 32,767 connections to an instance of the database
engine.

There is no limit for the number of connections that can be executing operations
at the same time. The only effect of the workload governor is that it starts slowing
down the database engine when more than eight operations are actively running
at the same time.

Once it has been activated, the workload governor limits performance by stalling
a user connection for a few milliseconds each time the connection requests a logical
read or write on any of the pages in the data files of a database.
(The governor does not affect log files.)

The database engine waits before every data page reference as long as there
are more than eight active concurrent operations. When the number of active
operations is eight or lower, the database engine does not wait before scheduling
any reads or writes.

50 simultaneous users does *not* equal 50 simultaneous connections.

Users do *not* request database operations at all times they are connected.

Some time is spent reading the results, too, which downlevels
the number of connections being accessed simultaneously.

A few milliseconds delay for an MSDE read/write operation is negligible,
and *no* read/write operation will be denied.

In any case, performance will be better for an MSDE database
than for an Access database when users are approximately 50.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Paul Clement" <Us************ ***********@sws pectrum.com> wrote in message
news:3l******** *************** *********@4ax.c om...
On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:

¤ Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net
¤ worker process", therefore doesn't that mean that even 50 simultaneous human
¤ users of the website would appear to the database backend as a single user.
¤ Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database
¤ backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous
¤ change to make while NOT limiting the number of simultaneous web users in
¤ any way?
¤

As Bob mentioned in one of his posts you may want to keep in mind the that MSDE has a
Workload
Governor that will throttle connections when there are more than eight concurrent
operations. This
could perceptibly affect performance when using MSDE.
Paul
~~~~
Microsoft MVP (Visual Basic)


Nov 19 '05 #9
Hi Dan:

In addition to the other good advice, I'll point out the moving to
MSDE now will put you in an easier position to move to SQL 2005
Express when it ships. There is no workload governor in 2005 and the
feature set compared to Access is even greater.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net
worker process", therefore doesn't that mean that even 50 simultaneous human
users of the website would appear to the database backend as a single user.
Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database
backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous
change to make while NOT limiting the number of simultaneous web users in
any way?


Nov 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
17623
by: Tim Morrison | last post by:
SQL Server 2000 - MSDE 2000 Is there a way to get the number of current users logged into a SQL 2000 Server (also MSDE)? Cant be distinct users as most users are logged into the database using the same login. -- Tim Morrison -------------------------------------------------------------------------------- Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.
3
6120
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing Database) This asks for the name of the .adp file to create and then launches into the Data Link Properties dialog box (so far so good) I select my MSDE server from the drop-down, enter the sa account & passwd, attach a database file and try to...
1
1559
by: Mitch Olson | last post by:
Hi our company is just about to embark on developing a PIM-type application and would like to use .NET (VB6 is our distant option 2). The question we are currently investigating is whether the minimum machine requirements (processor speed & memory) will rule out too much of our target market (the universe of Windows users, well at least W98+ users). Our primary question is what is the minimum specification of a machine to run a...
5
3501
by: Robin Tucker | last post by:
I'm looking for a simple way of telling (inside a stored procedure) if I'm currently using MSDE or a full SQL server. Ideally, there is some pre-defined environment variable that won't cause me too much overhead. The reason I'm doing this is because my system "rolls over" databases when it reaches the 2Gb limit with MSDE, but obviously I want to avoid this overhead if the user installs onto a full SQL server instance. Thanks
8
3810
by: Stephen Corey | last post by:
I'm writing an app that basically just appends text to a text file on a Win2K Server. They fill out a form, click a button, and 1 line is appended to the file. Multiple people will run this app at the same time, and all will write to the same file. If I do an immediate flush() on the file after writing the line, is there still a risk that 2 simultaneous writes will collide? If so, what's the best way to handle this type of file write? ...
4
1568
by: Anthony P. Mancini | last post by:
Does anyone know how to make the MSDE do SQL authentication ? It appears to authenticate using Windows at all times. Thanks, Anthony
1
2297
by: Mark | last post by:
What's the best way to simulate 30 simultaneous web users without: 1. Asking our 30 favorite friends to participate 2. Opening 30 different browsers manually on my desktop. Thanks in advance. Mark
1
10055
by: Simon | last post by:
Is there HTTP connection limit of 2 simultaneous connections in webservices? For example what hapens if you use webservices form ASP.NET web application? Presumably ASP.NET is webservices client to some remote server. Does that mean that the requests would be compete over those 2 connections? Is there a workaround for this? RFC 2068 8.1.4 Practical Considerations Clients that use persistent connections SHOULD limit the number of
1
2220
by: accyboy1981 | last post by:
Hi, I currently looking into creating a website that is database driven in asp.net 2.0 and using C#. In creating this website there could be a maximum of 350 simulataneous accessing the website/database. My question is in using ASP.NET and SQL Server 2005 can they handle 350 simultaneous users? If not what is an alternative? Thanks in advance
0
8728
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9366
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9059
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6668
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5977
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4484
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4751
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3187
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2572
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.