Is ADODB.Recordset needed?

[dmaster]

DNS already set up eg "test"

Example:
<% dim conn, getData
set conn = server.CreateObject("ADODB.Connection")
conn.open "test"

set getData = conn.execute("SELECT * from table;")
do while not getData.eof
response.write getData("name")&"<br>"
getData.Movenext
Loop
getData.Close
Set getData = nothing
conn.close
set conn = nothing
%>

I have been using this type of coding for very advanced asp websites with no aparent problems.
My Server Spec.
Raq 4
MySQL 3.23.54-log
Chilisoft ASP 3.6

Everywhere I look they say to use ADODB.Recordset to access the data within the connection. Is this important? Other words will using ADODB.Recordset improve efficiency,thus speed?

This has been baffling me for months.

[bslintx]

technically...yes,

DSN must perform a lookup in the registry. This lookup, while not overly expensive, does add up, especially if there are many concurrent connections.