|Subject||Re: [IBO] tib_storedproc vs. tib_dsql|
> Is it better (or more efficient) to use a tib_storedproc or aI doubt if there is very much difference but TIB_DSQL should be the
> tib_dsql that that executes the stored procedure (assume nothing is
> returned)? Thanks
most efficient (derives directly from TIB_Statement, the base level of
all the dataset type components). TIB_DSQL will work to return a
single row of result.
TIB_StoredProc derives from TIB_Dataset, which allows it to return
multiple rows of result (just like TIB_Cursor). Since it comes from a
higher level component there will be some additional code and
resources consumed over TIB_DSQL.
Geoff Worboys - TeamIBO