On Sat, 2 Aug 2003 00:48:45 +0000 (UTC), james_027 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.

Please - don't use "table" components with any C/S database engine (except
in some special cases).
Note: you 'subject' says "ib_query".
1. If you do this sort of operations _a lot_, then it may be a valid
comparison (for you). My guess is that this is of little significance.
2. Is this all you do? Maybe any operation after this is much faster in
IBO than in IBX - who knows ... (With table components, all bets are off!
- I hardly ever use them).

IBX is a "thinner" layer, and for (some) basic operations it probably is
(should be?) faster. View the whole picture - I think you'll have to do a
lot of work to approach the speed and functionality if IBO.


--
Aage J.