>However, if the application is running as a single user application
>or on a local network, how would this make a difference in speed? By

Data processed by stored procedures do not have to traverse the
network. All the processing happens on one machine, then a result set is
returned to the client. Depending on the speed/saturation of your network,
this can be quite a difference in performance.