Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using VIEWS on a local computer instead of the WAN?
Message
 
À
08/06/1998 10:35:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00105766
Message ID:
00105831
Vues:
31
>also, are you saying that using SQL Server would be faster on
>a WAN? :)

Yes. Because all of the query processing happens at the server, SQL Server only needs to send the results back over the wire. When you do a query with just VFP, VFP needs to pull at least part of the index over the wire to find the right records to return. It then has to bring those records over the wire. Generally, VFP performs best with a powerful workstation and a fast network. SQL Server's performance depends mostly on how powerful the server is (though both can be slow if your queries return a lot of data over a slow network).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform