sure:
create a table with ten columns VARCHAR(255)
populate 250,000 rows of data
run these:
inlineSQL.asp:[tt]
<%
set cn = Server.CreateObject("adodb.connection"

cn.open "connection string to my db"
for x = 1 to 100
set rs = cn.execute("select * from myHugeTable"

response.write("inline loop " & x & " - " & now() & "<br/>"

next
cn.close()
set cn = nothing
%>[/tt]
storedProc.asp:[tt]
<%
set cn = Server.CreateObject("adodb.connection"

cn.open "connection string to my db"
for x = 1 to 100
set rs = cn.execute("exec getAllFromHugeTable_sp"

response.write("SP loop " & x & " - " & now() & "<br/>"

next
cn.close()
set cn = nothing
%>[/tt] =========================================================
while (!succeed) try();
-jeff