>After two years of developing un VFP, I've only used parameterized (?)
>views when I MUST have information from different tables in one single cursor, and have always considered them a performance hit.
>
>Just recently I realized that in a network environment it might be a bigger performance hit to send a whole table through the nw, than just the info a given user needs, for instance, instead of sending the whole catalog, just send the required part number.
>
>But, wouldn't it load the whole table to crate the view in a normal application.
>
>THIS IS THE ACTUAL QUESTION :)
>
>Do I need to develop a client/server application to reduce the network traffic and see a performance improvement.
>
>The thing is I usually consider only how my program performs on my development PC, and brand it as acceptable or non acceptable performance, but how it performs over a network is a whole different story.
>
>thanks in advance for sharing your experience
First and the most important fact is that Foxpro never moved whole tables around the network. If it would be so, this product should be trashed years before.
Secondly, query optimization is important chapter of VFP development. Generally speaking, in LAN environment you may tune your application so well, that it will perform better than Client-Server. I mean total cost-efficiency: you will get comparable performance for lower price (development & maintenance).
Edward Pikman
Independent Consultant