RDS too slow in IIS 6.0 - Help please

From: Sergey Petrosyan (spetrosyan_at_bcc.ru)
Date: 03/11/04


Date: Thu, 11 Mar 2004 20:06:54 +0300

We migrate web application to IIS 6.0 from IIS 5.0.

But code using RDS execute too slow with IIS 6.0 native mode.

Example:

<OBJECT ID="RDS1" WIDTH=1 HEIGHT=1
CLASSID="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E36">

</OBJECT>

<b> RDS Perfomance </b><a href=# onclick="jsrds()">test</a><br>

<script LANGUAGE="javascript">

function jsrds(){

            DF = RDS1.CreateObject("RDSServer.DataFactory", "http://<%=
Request.ServerVariables("SERVER_NAME")%>");

            dt=new Date();

            objADORs = DF.Query("Provider=sqloledb;Initial
Catalog=ANY_DB;User ID=XX;Password=YY;", "Select * from ANY_BIG_TABLE");

            dt = eval((new Date() - dt)/1000);

            alert("Count: "+objADORs.RecordCount+"\r\nTime: "+dt)

            }

</script>

This code execute about 100 seconds in IIS 6.0 native mode in our
environment, but on ISS 6.0 with IIS 5.0 isolation mode (or simply in
IIS5.0) - 3 sec. We can't use IIS 5.0 isolation mode.

Thanks in advance.
Serg.



Relevant Pages

  • RE: SCCM 2007 R2 & IIS7
    ... After further testing we have identified that IIS was dropping the HTTP ... request in favour of the HTTPS we have setup for Native Mode. ... The Certificate installed on the client sitting on the remote Forest\Domain ...
    (microsoft.public.sms.setup)
  • ISS 6.0 & Active Directory
    ... I'm wondering if IIS 6.0 stores the AD information? ... Win 2003 Active Directory in Native Mode. ...
    (microsoft.public.inetserver.iis.security)
  • Re: remote file access in .net app
    ... It turns out it had to do with IIS setting. ... The web server that did not ... have access to the remote directory was running in IIS 5 isolation ... After making it run in IIS 6 native mode, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Adjusting processModel settings
    ... While attempting to alter the processModel settings in my ... "When ASP.NET is running under IIS 6 in native mode, ...
    (microsoft.public.dotnet.framework.aspnet.security)