Yes, slow.
Never had a user that actually liked the experience.
Never bad enough to make management think that
the users had a problem.
But bad enough to make management think that management
had a problem if management had to use the application.
And that was using a fairly well designed application.
Depends a lot on the network infrastructure, not so much
at all on how far physically.
Latency is more important than through-put. Or at least,
you can fix through-put problems just by fixing up your
design.
Exaggerates all of the problems of ODBC-linked table design.
-- complex multi-table joins will be candidates for re-design
as views.
(david)