Subject RE: [IBO] One IB_StoredProcedure vs. many IB_StoredProcedures ?
Author Jason Wharton
> I'd like to know which approach is better:
>
> - A single IB_StoredProcedure component on a
> form, changing the Procedure-Name / -Parameters
> on runtime dynamically or
> - Several individual components for each
> StoredProcedure I use ?
>
> It's a rather large app. with several dz.
> similar procedures.
>
> Is there any major difference regarding
> speed / overhead etc. ?

I prefer to have separated components when something is potentially going to
be reused over and over.

If something is going to be used occassionally then I will tend to have one
component that gets revised, used, and then Unprepared.

You trade using up resources on the server (and client) to have prepared
statements ready and waiting to get snappier performance.

Jason