Best way to open RecordSet 1

[raywesterhoff]

What is the best (fastest, lowest use of server resources) to open a recordset?

I have seen:

rs.Open SQL, Conn
rs.Open SQL, Conn, 3
rs.Open SQL, Conn, 1, 1
rs.Open SQL, Conn, adOpenStatic
rs.Open SQL, Conn, adOpenKeyset

Is there a good resource out there to help me determine what is best for me and my company/application?

Thanks in advance.

 

[Spellman]

The speed of the recorset depends on the connection and what type of database your using. All the above will open the recorset. The options dictate whether or not it's readonly, updatable what type of locking you want done etc.

 

[rac2]

Beginning ASP Databases by John Kauffman from WROX addresses performance questions for sundry topics such as types of cursors.

The more things you specify in your code the fewer things the system has to figure out, but then the system is really fast, and I believe the defaults are usually most the most efficient options.