Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views with SQL Server 7.0 are very slow, any suggestion?
Message
De
16/02/2000 11:33:44
Walter Meester
HoogkarspelPays-Bas
 
 
À
16/02/2000 11:04:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00332897
Message ID:
00332917
Vues:
24
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform