This is example SQL:
select TABLE_1.NAME, TABLE_2.NAME, TABLE_3.NAME, TABLE_2.LENGTH,
TABLE_2.LANGUAGE_ID
from TABLE_4
join TABLE_1 on TABLE_1.ID = TABLE_4.T1_ID
join TABLE_2 on TABLE_2.ID = TABLE_4.T2_ID
join TABLE_3 on TABLE_3.ID = TABLE_2.T3_ID
where TABLE_4.T2_ID = :T2_ID

This one is called for different parameters ':T2_ID'.
I though that I maybe should put join clauses into 'JoinLinks'
property...?


Neczka

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 02:46 PM 8/09/2003 +0000, you wrote:
> >Could someone tell me, if there are some properties which should be
> >set when creating TIBOQuery object during runtime in order to
obtain
> >best performance (speed) of query?
> >
> >I'm asking, because after convertion BDE->IBO, the same functions
> >(which executes sql queries) work slower (!).
>
> That's a large question. Show us the SQL of the queries that work
slower.
>
> Helen