i have a question concerning outer-joins. maybe it was asked before but i couldn't find it (sorry for that inconvenience).
a have a query:
query q:query-prepare(
"for each company,
first p left outer-join where company.key = p.key,
first adress left outer-join where company.key1 = adress.key1 and
company.key2 = adress.key2
first p1 left outer-join where company.key = p1.key,
first adress1 left outer-join where company.key1 = adress1.key1 and
company.key2 = adress1.key2
first p2 left outer-join where company.key = p2.key,
first adress2 left outer-join where company.key1 = adress2.key1 and
company.key2 = adress2.key2
first p3 left outer-join where company.key = p3.key,
first adress3 left outer-join where company.key1 = adress3.key1 and
company.key2 = adress3.key2
");
this query slows down the entire program
especially if i do:
get last q.
where is the problem?
what am I doing wrong?
a have a query:
query q:query-prepare(
"for each company,
first p left outer-join where company.key = p.key,
first adress left outer-join where company.key1 = adress.key1 and
company.key2 = adress.key2
first p1 left outer-join where company.key = p1.key,
first adress1 left outer-join where company.key1 = adress1.key1 and
company.key2 = adress1.key2
first p2 left outer-join where company.key = p2.key,
first adress2 left outer-join where company.key1 = adress2.key1 and
company.key2 = adress2.key2
first p3 left outer-join where company.key = p3.key,
first adress3 left outer-join where company.key1 = adress3.key1 and
company.key2 = adress3.key2
");
this query slows down the entire program
especially if i do:
get last q.
where is the problem?
what am I doing wrong?