Subject | Re[2]: [IBO] Is IBX better than IBO when used threaded ? |
---|---|
Author | Carlos H. Cantu |
Post date | 2003-11-05T15:26:34Z |
So now you are in the right way ;)
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)
PFSL> No doubt the fact that TIB_Cursor is unbuffered (compared to
PFSL> TIBOQuery that is not), is one of the major reasons I see a hugh
PFSL> speed gain. Also I am doing things a bit different now: E.g. several
PFSL> places when I needed to insert new data I would use a TIBOQuery
PFSL> where I would set SQL.TEXT to somthing like "select f1, f2, f3 from
PFSL> table where f1 = :f1" (then "Open", do a lot
PFSL> of "Insert"/"Post", "Close"). I now use a IB_DSQL where I simply set
PFSL> SQL.TEXT to something like "insert into table (F1,F2,F3) values
PFSL> (:F1, :F2, :F3)".
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)
PFSL> No doubt the fact that TIB_Cursor is unbuffered (compared to
PFSL> TIBOQuery that is not), is one of the major reasons I see a hugh
PFSL> speed gain. Also I am doing things a bit different now: E.g. several
PFSL> places when I needed to insert new data I would use a TIBOQuery
PFSL> where I would set SQL.TEXT to somthing like "select f1, f2, f3 from
PFSL> table where f1 = :f1" (then "Open", do a lot
PFSL> of "Insert"/"Post", "Close"). I now use a IB_DSQL where I simply set
PFSL> SQL.TEXT to something like "insert into table (F1,F2,F3) values
PFSL> (:F1, :F2, :F3)".