open recordset without cursors

Question

generally, i connect to db with the following statement;

rs.open "query",db,1,3

now i tried (without cursors)

rs.open "query",db

the new one bring a big performance increase.

so i like to ask you if i don't set cursors in connection, what cursors are default?

Answer 1

CursorType = adOpenForwardOnly
LockType = adLockReadOnly

MSDN Reference

What you had were adOpenKeyset and adLockOptimistic.