Subject Re: [IBO] tib_storedproc vs. tib_dsql
Author TeamIBO
> Is it better (or more efficient) to use a tib_storedproc or a
> tib_dsql that that executes the stored procedure (assume nothing is
> returned)? Thanks

I doubt if there is very much difference but TIB_DSQL should be the
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
Telesis Computing