On 5/31/2004 at 3:50 PM Tim Ledgerwood wrote:

> Reasons to choose stored procedures :
>
> 1. Speed. Even if you are running the DBMS on the same machine as the
> application, your code will run considerable faster - rough tests that I
> have done show that a SP runs about 30% faster than a query, and about
> 70%
> faster than direct table access (for example, in Delphi, using a TTable
> component) It's easy enough to set up a test for yourself to show this.
>

My experience with this was the exact opposite. Contrary to all my expectations, the SP I tried ran twice as slow as the same logic executed from the client process using IBPP. Logic that required 30 seconds when run through the client required just over 60 seconds when run via SP. I may well have done something wrong, but have no ready explanation for what that might have been.


Dan.