Lukas Kahwe Smith wrote:
> One major difference of MySQL is that it provides SQL hints. This
> alleviates the issues with slow complex joins, but is obviously a
> dangerous tool if not used wisely. That being said, it can often be a
> very quick fix, whereas in PostgreSQL you do not have such tools if you
> ever need them.
One more thing .. MySQL currently has horrible performance for sub
selects. This will improve slightly in 5.1 and is scheduled to be
"solved" with 5.2
regards,
Lukas