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.

 

[ToddWW]

Here's a great FAQ on that very subject.

faq333-618

ToddWW