Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
do unitl rs.eof
response.write rs("lastname")&"<br>"
rs.movenext
loop
Throw the result into an array right away using getrows() and close your db before moving on.Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
If the SQL is working fine directly then there is no reason they wouldn't be just as fast in code. Which should lead you to the conclusion that your ASP code is the cause of the problem. (assuming its not down to hundreds of people trying to access the site at the same time.)