Sam Terburg <[EMAIL PROTECTED]> wrote: > 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 plan is to reduce this to 3 queries, perhaps in 1.7, if we find the time.. (I've good hopes that this is possible) I've no real solution now. Can't you do two separate'lists'? <mm:list path="bookings,test_centers" /> and <mm:list path="bookings,test_modules" /> or so? Perhaps you can use 'referids' or 'jspvar' for reusal. Michiel -- mihxil' Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 []()
