The fastest should be

for
select a.ID_Link, b.Title
from table1 a
join table2 b on (a.ID_Link = b.ID)
into :x, :y
do ...


IB is optimized for SQL-2 Join Syntax :-)

Besides that, I think that such questions are more appropriate in
IB-Support, another list here on yahoogroups, which is specialized on
IB-Specific things, here most people are expecting IBO-specific
questions.

Cu,

Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618

nick.josipovic@...

> -----Original Message-----
> From: hundri_106@... [mailto:hundri_106@...]
> Sent: Saturday, November 17, 2001 5:27 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] performance question
>
> Which should be used to get the best performance when using these
> similar queries:
>
> for
> select a.ID_Link, b.Title
> from table1 a, table2 b
> where a.ID_Link = b.ID
> into :x, :y
> do ...
>
>
> OR
>
> for
> select a.ID_Link
> from table1 A
> into :x do
> begin
> select b.Title
> from table2 B
> where b.ID = :x
> into :y
> end
>
>
>
> Just curious,
> Hundri
>
>
> ------------------------ Yahoo! Groups Sponsor
>
>

________________________________________________________________________
__

> _
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>

________________________________________________________________________
__

> _
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/