Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View is slower?!?!?!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00311191
Message ID:
00316978
Vues:
18
Rich,

My experience with remote views is with a Fox database on the backend. I do not know if the following comments apply to SQL Server, Oracle, etc...

A remote views work very well for updating, inserting and deleting data. They are extremely slow, however, for record selection. This is because VFP pulls the entire dataset before applying any filters. For this I use SQL Passthrough to query the data, and the database only sends the filtered dataset.

I do not believe that you can call a stored procedure in a remote VFP database.

Phil
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform