Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExpress 2008 performance
Message
 
 
To
07/08/2009 12:51:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01416770
Message ID:
01416792
Views:
66
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform