Pulling even the top 200 records can take 1-3 minutes. Very slow. We're trying to see what the delay is (it could be anything in the topology other than the driver). They don't have SQLServer on their system so we can't test pulling records from sqlserver as a comparison. In the past, adding an index tag in foxpro on the tables has improved performance, but we really don't know what may be the culprit here.
>Tracy,
>
>Hard to tell when we don't know the case of the behavior.
>For instance, try to play with setting the recordset cursorlocation. This is what helped me in the past:
>
> .CursorLocation = adUseClient
>
>
>
>>Foxpro tables exist across a T1 link. Using a winform (for testing but it will be a process on the server) in vb.net and OLEDB to ADO to grab data from vfp tables. Very slow. Recommendations? The best way to handle it?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"