Re:IBX Component Overhead
Not really. In order of performance it goes
TIBSQL
TIBDataSet
TIBQuery/TIStoredProc
TIBTable
Thsi is of course a generalization. TIBTable will usually open fastest, but
TIBSQL will scan fastest. TIBStoredProc will execute on the server a little
faster since the SP is already compiled. The above list is generally the best
performance and should also be the best from a network load.
Quote
Jim Morgan wrote:
> Under some circumstances it's possible to execute the same SQL (or
> equivalent) through any of 5 IBX components: TIBTable, TIBQuery,
> TIBStoredProc, TIBDataSet, or TIBSQL. Is there documentation on the
> relative load on server, load on client, and load on network associated
> with each of these?
> TIA,
> Jim Morgan
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
The bond that links your true family is not one of {*word*76}, but of respect and joy
in each others life. Rarely do members of one family grow up under the same
roof. (R Bach)