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 ***