Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views with SQL Server 7.0 are very slow, any suggestion?
Message
From
16/02/2000 11:33:44
Walter Meester
HoogkarspelNetherlands
 
 
To
16/02/2000 11:04:35
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00332897
Message ID:
00332917
Views:
25
Luis,

You may want to use Stored procedures and SQL passtrough techniques rather than using the remote views. Also check if the proper indexes are available in the SQL server database to optimize your query.

How much data is downloaded to the client ? How much is updated ? Do you need all that data ? IOW give us some more info.

Walter,

>I have an app that uses views, the time they take to 'load' and the time they take to update are driving me crazy they are so slow that all users are very angry. Is there any solution to this. Someone can help me please?
>
>TIA,
>
>Luis Guerra
Previous
Reply
Map
View

Click here to load this message in the networking platform