Subject Re: [IBO] is it my ib_query or ib_grid is slow?
Author Helen Borrie
At 03:06 AM 6/08/2003 +0000, you wrote:
>Can anyone address to this issue?

What is the issue?

Helen


>thanks
>
>
>-- In IBObjects@yahoogroups.com, "james_027" <james_027@y...> wrote:
> > Recently I made made a test. Using ibx with db_grid vs ibo with
> > ib_grid. Scrolling from first to last record(on the first instance)
> > ibx is about 400% faster. It took about 1 sec compare to 4 seconds
>on
> > ibx. I have about 50,000 records. I have my second testing which
>uses
> > this code both on ibo and ibx.
> >
> > table.first;
> > while not table.eof do
> > begin
> > table.edit;
> > table.fieldbyname('fielda').asinteger:=table.fieldbyname
> > ('fielda').asinteger+100;
> > table.post;
> > table.next;
> >
> > end
> > table.ib_transaction.commitretaining; // for ibo
> > table.transaction.commitretainning; // for ibx
> >
> > Sad to say that the result is not favor to ibo. It took 4mins
>15sec
> > on ibx and 10 min 23 secs on ibo.
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/