>>>>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.
>>
>>Speaking in computer terms, War and Peace is just 3.1 MB in size. How long could that be? :)
>
>Try sending 3.1 MB of data over a slow network connection (10BaseT or worse). Can you say coffee break?

I have 10BaseT at home and when the first pages appear on my PC, if I run to another PC in a next room, I am still able to notice the phrase "The End" disappearing from the screen. :)