>Do stored procedures in the DBC run on the Server that the DBC is located on or in the memory of the client?
>If they run on the client, wouldn't it be faster not to use stored procedures and use procedures that are located on the client itself?

As Jason said, the VFP SPs run on the client workstation. The compiled code is loaded into memory and executed. FWIW, the same is true with regard to SPs running via triggers accessed from ODBC.

As for the "local machine" increase in speed, the only speed increase with this technique is the time it takes to actually load the procedure into memory. While loading something from your local hard drive is faster than loading something over the network wire, you won't notice the difference unless you are loading War and Peace.