Also sometimes the problem is that if you dump thousands of line, the task
is done quickly server side but the network has quite a huge job to transfer
the page.
You may want to check the size of the page to see if its small enough...
Patrice
--
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> a écrit dans le message de
news:Or**************@TK2MSFTNGP09.phx.gbl...
"joethis" <jo*****@discussions.microsoft.com> wrote in message
news:3E**********************************@microsof t.com...
I have a query that returns a resultset rather fast, but when I
go through
the loop to write it out to the page I get a slow display. Is
there a way
to speed this up?
do while not rs.EOF
Response.Write rs("col_name")
rs.MoveNext()
loop
http://www.aspfaq.com/show.asp?id=2467
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.