I once again have a question. I have the following relations.
bookings -> test_centers bookings -> test_modules bookings -> client_login
if i want to show a list on screen containing field of all those tables i do the following:
<mm:list path="test_centers,bookings,test_modules,bookings,client_login" constraints="c.number=g.number">
is there an easier way of doing this.
because this query takes longer because it has to gather all the relations with bookings twice.
This is only part of the whole construction. in fact there are 9 different tables which makes the query very very slow, taking 45 minutes (mysql is dumb).
fortunately there's mmbase-caching, unfortunately the constraint changes every time.
using the <related>-tag is also an ugly sollution because then it would execute thousands of queries.
<mm:nodelist type="bookings">
<mm:relatednodes type="test_centers">....
<mm:relatednodes type="test_modules">....
</mm:nodelist>
The second question i have is: can mmbase make outer joins.
I want to return a list containing fields from bookings and test_centers where bookings doesn't always have a relation with test_centers.
-- Sam Terburg ___________________ MagicMinds Interaction Technology Prins Hendrikkade 20/21 1012 TL Amsterdam t 020.5217002 f 020.5217097 m 06-21892736
