Re: IIS 6.0 bottleneck when serving ASP pages

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Egbert Nierop \(MVP for IIS\) (egbert_nierop_at_nospam.invalid)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 08:15:48 +0200

Quit simple,
upgrade to the free MSDE and get rid of access. 40/50 anymous users at a
time, means about 2/3 paralell requests to the access database. Access will
choke on this, in an internet environment.
http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp

>advanced ODBC settings that sped things up

not at all, since not ODBC is the bottleneck, but the JET monolithic driver.
And believe me, MS won't fix access for this, it would mean that they change
access to act as MSDE :) 

-- 
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm
"Geoff Winsor" <geoff@brinkman.mbb.sfu.ca> wrote in message
news:catkmu$cs3$1@morgoth.sfu.ca...
> Hi,
> I just finished migrating our web site to Windows server 2003 from Windows
> 2000.  It consists of a mix of static html and .asp pages that mostly
> connect to MS access databases on the back end. Before going live with the
> changes, everything worked very well. After going public, IIS 6.0
continues
> to serve the static html pages with no problem but chokes on the ASP pages
> (however not timing out), even though the web traffic is not high (around
40
> or 50 anonymous users at a time). I dont think it is a problem on the back
> end since we had that problem once before and made some changes under the
> advanced ODBC settings that sped things up. In addition a couple of the
.asp
> pages only serve html and exhibit the same problem.
> Can anyone provide some insight into how this can be optimized.
> Thanks,
> Geoff
>
>
>

Relevant Pages

  • Re: To Web or to synchronize? That is the question.
    ... putting together an Access database and ASP, ... Jet replication is a really great tool if you have laptop users ... Server, and just host the app on a Windows Terminal Server in the ... the ASP solution and Lyle's SQL ...
    (comp.databases.ms-access)
  • Re: IIS 5 100% CPU troubleshooting tools - IISState?
    ... strong correlation and I put the site into high isolation (and the customer ... ASP requests queued -- and they seemed stuck, ... In this case he is using an Access database with a connection string ...
    (microsoft.public.inetserver.iis)
  • Re: Only want to insert a record
    ... > scripting with a local MS Access database. ... When executed within an asp page ... which lets you do whatever your user permissions allow. ...
    (microsoft.public.data.ado)
  • Re: some advice please
    ... where it's possible to access database from VB. ... "Jeff Cochran" wrote in message ... > elements as others are selected (check a client side or DHTML group ... >>form needed because no variable to pass to ASP. ...
    (microsoft.public.inetserver.asp.general)
  • Re: some advice please
    ... where it's possible to access database from VB. ... "Jeff Cochran" wrote in message ... > elements as others are selected (check a client side or DHTML group ... >>form needed because no variable to pass to ASP. ...
    (microsoft.public.inetserver.asp.db)