title: Most efficient way to find record in ADO Recordset with multiple criteria? (VB6)
body: <p>I am converting some old legacy Access code to SQL for our legacy program in which we create a report based on thousands of records worth of data. We use multiple recordsets to access varying records/tables. Previously (in access), we found the desired records in the recordset(s) using the Recordset.Seek function. Doing this gets us the data we want in a manner of seconds. </p>
  
  <p>In converting this to work with SQL using the ADO Recordset instead of DAO, I found that most people recommended simply setting the recordset equal to a new recordset using a query that would return the desired records. This has been the most efficient way to do this so far, but this still takes up to 2 minutes to get the same data that took seconds in access. </p>
  
  <p>I see that the ADO Recordset has a .seek function as well, but I am having trouble attempting to implement this to compare speed/accuracy. If this would be a better method, how do I create/set the Index of the recordset, and how do I know the name of the index?</p>
  
  <p>Thank you!</p>