Subject Re: [IBO] Interbase/IBO very slow ?
Author Geoff Worboys (TeamIBO)
> Are you using RequestLive for your queries? If so, maybe try using
> RequestLive:=False and use IBO's query editor to set up your
> statements(insert, update and delete).

Personnaly I dont like this approach - and only use it when IBO is
unable to construct appropriate SQL automatically. It has never given
me any performance problems.

Keep in mind that explicit Insert/Edit/Delete SQL statements are
prepared at the same time as the select SQL. Whereas if you let IBO
create its own Insert/Edit/Delete SQL then they are only prepared
if/when required.

I suspect your suggestion about indexes and using locate are probably
correct. Performing updates in code are much better using
parameterised TIB_Cursor or TIB_DSQL. Keep the buffered components
(TIB_Query etc) and the use of locate for interactive work.

Geoff Worboys - TeamIBO
Telesis Computing