Hi,
I just repeat the test:
select * = 0.8515625
select count(*) = 1.171875
Private Sub Command1_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim aaa As Long
Set db = OpenDatabase("f:\biblio.mdb") 'c on myserver
aaa = Timer
For i = 1 To 100
Set rs = db.OpenRecordset("select count(*) from authors", dbOpenSnapshot)
rs.Close
Next i
Debug.Print Timer - aaa
End Sub
Any idea?
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...