Subject Re: [IBO] How to improve performance of IBO.
Author TeamIBO
> In my applications I do a great number of select of few record and
> in some cases unsing always the same TIBOQuery component, closing it
> and setting every time a new sql statement.
> In past Jason tell me that IBO aren't optimized for this type of
> usage but I would like to know if there is something that i can do
> in order to increase performance.
> Why BDE, in this case, are faster then IBO, even BDE must connect to
> the server in order to execute the statement. I use Delphi4,
> IBO4.2Fn and FireBird RC2.
> ps. I can't use IB_ component.

I am curious about saying you cannot use IB_ components. If you are
setting up a new query and selecting a few records - it sounds like
you are doing this in code, rather than directly for the user
interface. In which case something like a TIB_Cursor may be
appropriate - for those instances.

Of course if you are needing to tie this to a TDataSource then you are
stuck with TIBOQuery, but it does seem from your description that this
is not the case (but I could be reading too much into it :-)

The next thing is to take a look at exactly what you are doing. What
SQL are you setting up, how are you selecting a few records from the
results. We may be able to help improve your SQL or the code that you
are using to do this.

If you run the IB_Monitor component you will be able to see what is
being sent to the server - and the timings involved. From this you
may be able to get some idea of where things are slow.

Geoff Worboys - TeamIBO
Telesis Computing