To be honest I have not personally tested the time difference, but am only repeating what I have read in Client Server documents.

As for percentage of time, well I am sure that depends on the query. If it is a really simple query, but has to be run many times in rapid succession, you might notice a significant difference in speed.


>Hi Erik,
>
>Just a curiousity, really. . .
>
>You say "the server view is faster, because the view code is precompiled". While I have no reason at all to dispute that fact, I *do* wonder about just how much faster the fact that it is precompiled actually makes it. I mean, how long can a compile of a SQL statement really take and what percentage would that time be of the whole?
>
>Regards,
>
>Jim N
>
>>>Which would be faster on a client/server app?
>>>
>>>Would a Local View use the processer power from the server when creating the subset of data to return to the client or do they both get processed in the client end?
>>>
>>>Thanks Ron
>>
>>What do you mean by local view? A VFP local view looks at VFP data. If you mean a view stored on the server, then the answer is- the server view is faster, because the view code is precompiled. All stored procs and views defined in the server database use the server's processor. Actually all operations on server databases run on the server- because clients don't have direct access to the files.