Local Access
(listed from fastest to slowest) 		Remote Access
(listed from fastest to slowest)
  1. DAO
  2. RDO, server-side cursor
  3. ADO OLE DB, server-side cursor
  4. RDO, client-side cursor
  5. ADO OLE DB, client-side cursor
  6. ADO ODBC, server-side cursor
  7. ADO ODBC, client-side cursor
  1. ADO OLE DB, server-side cursor
  2. ADO ODBC, server-side cursor
  3. RDO, client-side cursor
  4. ADO OLE DB, client-side cursor
  5. ADO ODBC, client-side cursor
  6. RDO, server-side cursor
Table 2 RDO and ADO Post Wins and Losses. The finishing order of the various data access methods contain some results you might have expected, such as ADO OLE DB with a server-side cursor recording the best score for remote data access. It also contained a handful of surprises, such as RDO with a server-side cursor recording the worst score for remote data access. More surprising, however, is the fact that DAO placed first overall in local data access, while ADO posted slower-than-hoped-for times in the local data access tests. You can use these results as a quick reference to the approaches you should try first when accessing local or remote data. However, you should strongly consider modifying the settings presented here to meet your database demands, then retest with the new settings to confirm the proper and most efficient approach.