At 15:52 28.01.02 +0100, you wrote: > > Your suggestion might work but I'm not sure if it's fast enough to be > > done "on-the-fly" (i.e. during a http user request) due to the fact that > > the tables are quite large and I have to "manually join" 10 tables :( > >I'd say that a UNION over 10 tables is a sure sign for a bad DB design.
That's for sure. Fortunately it wasn't my idea but unfortunately I'm not able to convert it so I have to use workarounds for now :( >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel: +49 (0)221 - 2949 154 fax: +49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php