I've just done some performace tests on three different ways of returning some records.

I used a recordset with a SQL query, the Seek method and the FindFirst method.

From what I have read the SQL method should be the fastest, but from my results I got, I found that Seek was fastest followed by the SQL method.

Is this right?