Large SQL table causes web page to hang

Michael Netherton · Michael Netherton

I am querying a large SQL database table and when the result set is large (over 1000 records), the browser just clocks and I have to wait for the session to time out and then the recordset will be displayed. I''ve tried setting response.flush to get the for next loop to display the data as it''s retrieved. No luck. The page won''t display anything until the for next loop completes or the page times out. The code is below:

if not rs.EOF then
rc = 0
while not rs.EOF
Response.Write "<tr>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("num") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("cst") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("dist") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("art") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("pd") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("shp") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("imp") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("mdnum") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("MRC") & "</td>" & vbcrlf
Response.Write "<td style=''border-left-style: solid; border-left-width: 1;border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1''><a href=''edit.asp?id=" & rs("ID") & "''>" & rs("ID") & "</a></td>" & vbcrlf
Response.Write "</tr>" & vbcrlf
Response.Flush
'' Response.Buffer = true
rs.MoveNext
rc = rc + 1
wend
end if

-----------------------------
This message is posted by [url]http://Asp.ForumsZone.com[/url]

only me · only me

sorry : forgot to say, look at 'paging' the data into more mangable 'screen'
sized chunks

"Michael Netherton" <mnetherton@mocap.com> wrote in message
news:301525267425581@Asp.ForumsZone.com...

> I am querying a large SQL database table and when the result set is large

(over 1000 records), the browser just clocks and I have to wait for the
session to time out and then the recordset will be displayed. I''ve tried
setting response.flush to get the for next loop to display the data as it''s
retrieved. No luck. The page won''t display anything until the for next
loop completes or the page times out. The code is below:

>
> if not rs.EOF then
> rc = 0
> while not rs.EOF
> Response.Write "<tr>" & vbcrlf
> Response.Write "<td style=''border-left-style: solid; border-left-width:

1; border-bottom-style: solid; border-bottom-width: 1''>" & rs("num") & "</td>" &
vbcrlf