Hi all,

Daniel Rail wrote:

> > Can anyone address to this issue?
>
> What about simply using the following SQL statement:
> UPDATE TABLE SET FIELDA=FIELDA+100
>
> This should be a lot quicker.
>
> Accessing a RDBMS in the same way you would Paradox, is not always
> the most efficient way. Sometimes, you have to learn what can be
> done natively with the RDBMS.

But what James did is still interesting as a speed test, and he found
IBX 2.5 - 4 times as fast as IBO (in these particular tests). Maybe
this is unavoidable, as IBO is a lot richer and therefore more
complicated than IBX.

James, what happens if you don't attach any DataSource to the queries,
and run the tests again?


Greetings,
Paul Vinkenoog