I’m accessing some VFP data from SQL server using a linked server. It takes 6 seconds to pull a single row from a small table using an indexed field. The same query within Fox is instantaneous.
I had thought that the OLEDB driver would make use of Fox indexes. That doesn't seem to be happening. The data is local to everything.
What kind of performance are others seeing?