Subject Re: [IBO] is it my ib_query or ib_grid is slow?
Author james_027
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.