ASP Recordset Question

Originally posted by : Craig Stadler (cstadler18@hotmail.com)I am using the following code to query a sql server database.My question is, can i have the recordset start returning records as soon as it gets 1 or does it have to build the ENTIRE recordset before output..I realize some performance is related to many factors but I want the loop below to begin once 1 ONE record is found. (Is this a multithread thing or a different recordset type or...?)Please respond via email alsocstadler18@hotmail.comThanks in advance.CraigI am querying a table of over 2,000,000 records.--- Code Snip ---Set myDB = Server.CreateObject("ADODB.Connection")Set myRS = Server.CreateObject("ADODB.Recordset")myRS.CursorType = 3 ' KeysetmyDB.Open "uid=id;pwd=pwd;driver={SQL Server};server=.;database=db;"myDB.CommandTimeout = 0SQL = "Select * from dbTable1 where ID = 999" set myRS = myDB.Execute(SQL)Do Until myRS .EOF Response.Write myRS ("Field1") myrs.movenextLoop---

Originally posted by : KKB TENNEKOON (ktennekoon@yahoo.com)------------Craig Stadler at 7/24/2001 1:50:32 AMI am using the following code to query a sql server database.My question is, can i have the recordset start returning records as soon as it gets 1 or does it have to build the ENTIRE recordset before output..I realize some performance is related to many factors but I want the loop below to begin once 1 ONE record is found. (Is this a multithread thing or a different recordset type or...?)Please respond via email alsocstadler18@hotmail.comThanks in advance.CraigI am querying a table of over 2,000,000 records.--- Code Snip ---Set myDB = Server.CreateObject("ADODB.Connection")Set myRS = Server.CreateObject("ADODB.Recordset")myRS.CursorType = 3 ' KeysetmyDB.Open "uid=id;pwd=pwd;driver={SQL Server};server=.;database=db;"myDB.CommandTimeout = 0SQL = "Select * from dbTable1 where ID = 999" set myRS = myDB.Execute(SQL)Do Until myRS .EOF Response.Write myRS ("Field1") myrs.movenextLoop---