If I run the following more than once then the later instances block until the earlier ones finish. It was my understanding that ASP was multithreaded...?
If I use the perfomance monitor then at most all I get is one ASP process executing and one in the queue
What am I missing here?
Cheers
<%@ LANGUAGE="VBSCRIPT" %>
<%
Option Explicit
Response.Expires = 0
Response.Buffer = False
%>
<head>
</head>
<HTML>
<BODY>
<CENTER>
<%
Dim objConn, intCount
Response.write "Begin: " & FormatDateTime(Now(),vbLongTime)
' Open connection to DB
set objConn = Server.CreateObject("ADODB.Connection"
objConn.open "Driver={SQL Server}; Server=CS09; Database=Harry; UID=sa; PWD="
%>
<TABLE BORDER="1">
<TR>
<TD><SPAN ID="Count">-</SPAN></TD>
</TR>
</TABLE>
<%
For intCount = 1 to 1 step -1
If (Not Response.IsClientConnected) then Exit For
%>
<SCRIPT LANGUAGE="JavaScript">
document.all("Count".innerHTML = "<%=intCount%>";
</SCRIPT>
<%
objConn.Execute "WAITFOR DELAY '00:00:01'", , adCmdText + adExecuteNoRecords
Next
%>
<SCRIPT LANGUAGE="JavaScript">
document.all("Count".innerHTML = "0";
</SCRIPT>
<%
Response.write "End: " & FormatDateTime(Now(),vbLongTime)
%>
</CENTER>
</BODY>
</HTML>
[sig][/sig]
If I use the perfomance monitor then at most all I get is one ASP process executing and one in the queue
What am I missing here?
Cheers
<%@ LANGUAGE="VBSCRIPT" %>
<%
Option Explicit
Response.Expires = 0
Response.Buffer = False
%>
<head>
</head>
<HTML>
<BODY>
<CENTER>
<%
Dim objConn, intCount
Response.write "Begin: " & FormatDateTime(Now(),vbLongTime)
' Open connection to DB
set objConn = Server.CreateObject("ADODB.Connection"
objConn.open "Driver={SQL Server}; Server=CS09; Database=Harry; UID=sa; PWD="
%>
<TABLE BORDER="1">
<TR>
<TD><SPAN ID="Count">-</SPAN></TD>
</TR>
</TABLE>
<%
For intCount = 1 to 1 step -1
If (Not Response.IsClientConnected) then Exit For
%>
<SCRIPT LANGUAGE="JavaScript">
document.all("Count".innerHTML = "<%=intCount%>";
</SCRIPT>
<%
objConn.Execute "WAITFOR DELAY '00:00:01'", , adCmdText + adExecuteNoRecords
Next
%>
<SCRIPT LANGUAGE="JavaScript">
document.all("Count".innerHTML = "0";
</SCRIPT>
<%
Response.write "End: " & FormatDateTime(Now(),vbLongTime)
%>
</CENTER>
</BODY>
</HTML>
[sig][/sig]