No doubt the fact that TIB_Cursor is unbuffered (compared to
TIBOQuery that is not), is one of the major reasons I see a hugh
speed gain. Also I am doing things a bit different now: E.g. several
places when I needed to insert new data I would use a TIBOQuery
where I would set SQL.TEXT to somthing like "select f1, f2, f3 from
table where f1 = :f1" (then "Open", do a lot
of "Insert"/"Post", "Close"). I now use a IB_DSQL where I simply set
SQL.TEXT to something like "insert into table (F1,F2,F3) values
(:F1, :F2, :F3)".

> Also you cannot compare the performance of a buffered dataset like
> TIBOQuery (or even TIB_Query) with unbuffered comps like TIB_Cursor
> or TIB_DSQL.
>
> []s
>
> Carlos
> WarmBoot Informatica - http://www.warmboot.com.br
> FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)