On Wed, Feb 19, Wiktor Wodecki wrote:
I don't have anything specific in mind, I just know the limitations of MySQL regarding to subselects (okay, in the latest 4.1 alpha alpha they implemented them), this might bite in the future. I just want to get sure that we don't run into problems somewhere in the future. OTOH joins are very very ressources consuming (I've seen a large join by a webdesigner who killed the informix optimizer...). It isn't really an issue now, but I can imagine that I'd need to split up some of the bigger joins into multiple SELECT to enahnce performance on our system.
To summarize that: SQL92 is enough for you :-) greets, Daniel Rahn -- SuSE Linux AG | phone: +49 (0) 911 74053 0 Enterprise Support Services | fax: +49 (0) 911 74053 674 Deutschherrnstr. 15-19 | http://www.suse.de/en/support 90443 Nuernberg | GERMANY