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
Précédent
Suivant
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