Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExpress 2008 performance
Message
 
 
À
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:
01416792
Vues:
65
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform