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
msg00085/pgp00000.pgp
Description: PGP signature
