>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
Kelly,
On wiki site there were some benchmarks, check them. As per stored procs, with OLEDB it's very easy to call IMHO.
Cetin