|Subject||Re: [IBO] Interbase/IBO very slow ?|
|Author||Geoff Worboys (TeamIBO)|
> Are you using RequestLive for your queries? If so, maybe try usingPersonnaly I dont like this approach - and only use it when IBO is
> RequestLive:=False and use IBO's query editor to set up your
> statements(insert, update and delete).
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
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