RDS too slow in IIS 6.0 - Help please
From: Sergey Petrosyan (spetrosyan_at_bcc.ru)
Date: 03/11/04
- Next message: jallen: "Error - Are you there, Doug?"
- Previous message: Bryce: "Re: sbs2003 and printer on Machine A not granting access"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: jallen: "Error - Are you there, Doug?"
- Previous message: Bryce: "Re: sbs2003 and printer on Machine A not granting access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|