Subject | RE: [IBO] One IB_StoredProcedure vs. many IB_StoredProcedures ? |
---|---|
Author | Jason Wharton |
Post date | 2006-11-28T19:06:16Z |
> I'd like to know which approach is better:I prefer to have separated components when something is potentially going to
>
> - 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. ?
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