Re: Reasons of some limitations
"Reasons"... Here are some guesses:
* MySQL started out as a lean database engine. It did not have subqueries, transactions, partitions, character sets, nor the items you mentioned. Gradually, features have been added.
* Most missing features are so rarely used that there is not enough "customer pull" to cause them to be added.
* Most features have workarounds. (FULL OUTER JOIN can be implemented with a UNION.)
* Added features tends to add complexity, thereby adding bugs and slowdowns. When subqueries and partitioning were added, users used them only to find out that they did not help performance -- sometimes even slowed things down.
One of the features you mentioned is available now:
MariaDB added "Windowing functions" recently (version 10.2).
Subject
Written By
Posted
Re: Reasons of some limitations
May 23, 2016 10:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.