SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2005
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is ADODB.Recordset needed?

    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.

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •