>SP is probably faster for direct queries.

I doubt it'd be faster, except when you're calling a stored proc. If you're building the SQL in VFP, then passing it on, I wouldn't expect the performance to be different. SP is certainly a lot more flexible for queries though.

> My strong suspicion is that SP may be *slower* on updates in certain cases- because you either need heaps of preparation code at the client + management code at the server for partial updates, or you need to pass all fields back in an update and have them all updated.

I think there are several cases where it's slower. From what I've been able to find out so far, the performance differences are very inconsequential. Especially when you take into account that most Client/Server apps retrieve a single record (and maybe) it's children, then send the changes back. Whether you retrieve a small set of records via RV's, on-the-fly SPT calls, Stored Procs, etc. the performance differences appear to be negligible.

We have a customer that has developed an application using all remote views that manages $30 Billion in mutual funds and they haven't run into any performance or scalability problems. I'm checking with them on the # of simultaneous users and other pertinent via e-mail now. I'll post what I find out.