Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
John,
>>This also adresses SQL-queries on SQL server.
>No it does not, since you did not use SQL-Server.......
IMO it applies to SQL server too.
>>To my limited knowledge
>This pretty much damages the credibility of your argument here...
>>the strategy of SQL on a SQL-server is comparable with those of VFP. The intermediate results are also stored either in memory or on disk. I'm just pointing out that it would better to follow the described strategy in at least some cases.
>You are basically saying that the VFP engine and the SQL-Server engine are on equal footing... This would be incorrect...
In this field, i'm saying yes, SQL-server uses the same strategy as VFP. If you want to argue this point, come with FACTS. To doubt my theory in this way is inappropriate.
I challenge you John, can you PROVE that SQL server does not store intermediate results, before it sends the result to the client ???
>>Also note that my test seems to tell us that it less stresses the network, which indeed was an issue here. I've talked about redundant data send back by the SQL-server in end-users reports. If you'd look carefully this VFP approach would NOT have this problem because the data is combined at the client side and only downloaded from a remote site once.
>This test tells us absolutely nothing that we already don't know, the fact that at times, in a VFP-only environment, X-base constructs can be more effective than SQL syntax...
I didn't know you'd know that, I'm glad you agree here.
Walter,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement