Re: Query for an Auction
- From: "Lyle Fairfield" <lylefairfield@xxxxxxx>
- Date: 17 Jul 2006 14:59:49 -0700
Nick 'The Database Guy' wrote:
Hi Worldbadger,
Think is that I would have my doubts about using an access application
with a front end application that can have potentially unlimited users.
Access can only handle, at the very most (and I am open to correction
if anybody has other opinions) 20 users.
ASPs can't maintain a connection [and there are no pills for that].
They connect for a few millionths of a second. They get some data. They
write some html. They send the html to client's browser. They close.
Any connection they may have had is gone forever, even if the ASP
writer didn't explicitly close it.
The cleint may modify delete or add something in the html form. Then
it's submitted to an asp file. The ASP file connects for a few
millionths of a second to effect the changes. It may write and send
some more html. Then it closes. The connection is history.
There are no Concurrent Users with ASP, or it's just a freak if there
are.
A lotta people can use an ASP page. Probably the Web Server is going to
choke before the Access DB does.
.
- References:
- Query for an Auction
- From: worldbadger
- Re: Query for an Auction
- From: Nick 'The Database Guy'
- Query for an Auction
- Prev by Date: Re: Access XP and Windows XP 64-bit
- Next by Date: Re: Passing fieldname to a subroutine
- Previous by thread: Re: Query for an Auction
- Next by thread: Combo Box not displaying all rows
- Index(es):
Relevant Pages
|
|
