Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>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 ?
The same qwery In SSMS takes Less than a second while from VFP (connecting via ODBC) it takes more than 20 seconds.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement