I'm not sure what's going on...

I have a page that's loading very slowly. I've isolated the problem to a single database call.

Both sets of code execute equally fast...

strSQL = "sp_getall Loc=5"

set rs = dataConn.Execute(strSQL)

do while not rs.eof
fr = rs(0)
fd = rs(1)
fg = rs(2)

strOut = strOut & "line: " & fr & ", " & fd & " (" & fg & ")<br>" & vbcrlf

rs.movenext
loop

rs.close
set rs = nothing

================================================

strSQL = "sp_getall Loc=5"

set rs = dataConn.Execute(strSQL)

'do while not rs.eof
' fr = rs(0)
' fd = rs(1)
' fg = rs(2)

' strOut = strOut & "line: " & fr & ", " & fd & " (" & fg & ")<br>" & vbcrlf

' rs.movenext
'loop

rs.close
set rs = nothing

===============================================
I've checked the stored proc in the query window in SQL Server Management Studio and its very fast.

What might be happening here?