Subject Re: [IBO] fastest IB_Cursor... how???
Author Carlos GarcĂ­a Trujillo
i'm implementing an OLAP application, so with a TIB_Cursor i get some
data from the DB and fill some non DBAware controls with that
information... these are just for a dashboard so can be readonly...

i just was wondering if i have the right configuration for a
TIB_Cursor with this purpose??? some advise that i'm not seeing????

Thanx Helen, as always... =:-)

--- In, Helen Borrie <helebor@...> wrote:
> At 10:17 AM 6/09/2006, you wrote:
> >What properties must i configure to get the fastest as posible
> >IB_Cursor??... the data are just readonly and all the records in
> >cursor are nedded..
> >
> >i just put "CheckRequired" to False cause is just for readonly
> >purposes, and "ReadOnly" to True, but i want to know if there are
> >other porperty that i could set to gain better performance???
> What do you mean by "better performance"? Is your routine slow?
> IB_Cursor fetches each row one-by-one. If "performance" means
> you are measuring the time elapsed between when you call First and
> when the first record appears.
> Presumably, you are using IB_Cursor because you want to do some
> non-visual processing on a set (since IB_Cursor does not store
> records in a buffer). If what you are doing is slow and is not
> touched by human hands, you should consider performing the
> as a searched one, via a DML statement in an IB_DSQL, which would
> faster than anything you might achieve by pulling the set over to
the client.
> Helen