>>>No. the same problem.
>>>I run the query for an other table with 1200 rows without the TOP clause. The same problem very very slow.
>>>It seems to me that has to do with the connection or the server or the computer setup.
>>>The same tasks wark fine on a production environment LAN.
>>
>>Do you have SQL Server installed on this computer? Did you try queries in SSMS connecting to the server? How long does it take to connect to the server?
>
>SQL Server installed on this computer : YES
>Did you try queries in SSMS connecting to the server: YES and the same queries run fine. 1000 records in one second or less
>How long does it take to connect to the server : Less than a second
Did you measure just sqlexec statement?
lnSeconds = seconds()
sqlexec(..)
=messagebox(seconds()-lnSeconds)
Also how long would it take if you try
execute sp_ExecuteSQL 'Select top 1000 from Sometable' in SSMS ?
If it's not broken, fix it until it is.
My Blog