Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only