Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExpress 2008 performance
Message
De
07/08/2009 12:51:58
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01416770
Message ID:
01416787
Vues:
54
>>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
Fil
Voir

Click here to load this message in the networking platform