Posted by jim.clifford on 10/18/06 06:48

nigelrivett wrote:
> Sounds like it might be copying the table to the local server to do
> sorting maybe?
> My first thought wouldbe that the second call was fast because the data
> was in memory. Maybe the third was slow because something had purged
> that data?
>
> Try using the profiler on both machines to see what was executed on
> them.
>
> www.nigelrivett.net
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

I am sure it is not an issue with copying the data. I can continually
poll the remote DB manually and the speed is quick and it changes when
expected. The problem appears to be related to finding the path to the
remote server. This memory of where to look for the remote DB seems to
be short.

Regards JC......

[Back to original message]