IIS 5 & IIS 6
ADODB slow response over the network
Last post Nov 07, 2016 07:26 AM by Yuk Ding
Nov 04, 2016 11:47 AM|san_k_nwd|LINK
We are classic ASP programmer. We are using the database sql server 2005 management studio. ASP page is on one machine (Window server 2012 R2) and sql server 2005 management studio is on another machine (Window server 2003). When run the ASP page, It gives
very slow response.
Script look like this.
strsql="select * from test1" '' 25 records on this table
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strsql, objCnn
if not rs.eof then
while not rs.eof
id = rs("id")
qty="select count(*) as tcount from test2 where id=" & id
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open qty, objCnn
if not rs1.eof then
tcount = rs1("tcount")
rs.Close : Set rs = Nothing
when both database and ASP script on same machine then it does not take time to response. It gives response in 1-2 second but when both is in different machine it takes long time then gives the response. Some times it gives ScriptTimeout error.
We have opened the both database on the same machine and run the same query it does not take time. Query execute time is Approx.equal.
Is there missing any IIS or ADO setting?
Can you please help us?
Nov 07, 2016 07:26 AM|Yuk Ding|LINK
Now that your application could get correct response from database in local machine , it could have no problem with your code. The problem may be caused by the configuration or security policy. Please try to disable the firewall and anti-virus. Grant permission
for your anonymous user or windows authentication user to the different machine.
Besides, you could enable the failed request tracing to figure out which module is blocking the connection:
Failed request tracing log will record the spend time for each module via time taken.