Board index » delphi » IBX Component Overhead

IBX Component Overhead

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

 

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)

Other Threads