Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExpress 2008 performance
Message
From
07/08/2009 19:48:36
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
07/08/2009 18:43:06
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:
01416854
Views:
108
This message has been marked as the solution to the initial question of the thread.
Make sure ODBC trace is not turned on.

>>>It returns the results in less than a second.
>>
>>It doesn't. Management studio displays the result as soon as the first few dozens records are available. If you look closely, you see that the query is still executing, even though Management studio already displays a result. VFP waits for the query to be complete (or for a larger number of records) before it returns. If you execute the query asynchronously in VFP, you should get a result much quicker, too. VFP would keep loading in the background.
>
>It seems that it something wrong with my machine.
>I run the same queries in an other machine (more or less of the same capabilities) same database data etc
>and returns the results in light speed. The connection is established in a flush while in the one with the problem it takes about a second.
>Also something very strange:
> a) query1 select top 100 f1, f2, f3, .f4 from mydatabase.dbo.mytablerec it takes about 20 seconds
> b) query2 select top 100 f1, f2 from mydatabase.dbo.mytablerec it takes about 10 seconds
> c) query3 select top 100 f1 from mydatabase.dbo.mytablerec it takes about 5 seconds
>
>Is there a virus problem ? I am afraid that I have to format it and install everything again.
>But on the other hand other VFP programs work fine!.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform