I am trying to get some benchmarking information for an upcomming project concering a VFP application that uses SQL server as a back end. What we have now is an ODBC connection that is called using the SQLCONNECT() and SQLEXEC() functions. What I need to deterine is, is this the fastest and most efficient manner to retrieve a set of information?

Things that I have to consider:
1. ODBC vs. OLE?
2. If I use OLE, how can I mimic the functions that I am currently using?
3. Is there a better way of accessing a portion of data froma SQL table other than what has been used now, i.e. ado object or cursor adapter?
4. If I use these other avenues how would I call a stored procedure and return the results?

What I need is just a good starting point so I can run some tests and make an informed decision.

Thanks in advance
Kelly