StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>MySQL is not as cheap as you think. </p> <p>The big orgs that use MySQL spend considerable resources on keeping it running and often have to develop their own extensions. There have been several recent articles from MySQL insiders about the poor quality of their product. I've been a user of MySQL for several years and the quality of releases took a precipitous drop after change in ownership to SUNW. </p> <p>I realize that MySQL can be optimized and made to run well, but I'm not a dba and cannot afford to have a dba on all of my projects. I have several very complicated queries that sometimes cause the system to run out of memory. I am currently in the process of migrating my systems over to SQL Server Express. The test queries run significantly faster on SQL Server Express than they do on MySQL. If you are not very strong in databases and need a robust and fast system, I would not use MySQL. SQL Server Express is made more for developers with middle of the road knowledge of databases. They've automated and performance tuned a lot of things that you would have to do manually on MySQL.</p> <p>On the other hand, if you are very comfortable with databases, you may want to consider PostgresSQL. It is open source. It's not as user friendly as MySQL, but from my cursory understanding, it is more powerful and much more stable.</p> <p>bottom line - MySQL used to be a good option, but consider SQL Server Express and PostgresSQL as better current alternatives.</p> <p>EDIT:</p> <p>here are a few of the references. there were 2 other very scathing ones - but i got them off of reddit.</p> <p><a href="http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html" rel="nofollow noreferrer">monty-says</a></p> <p><a href="http://www.mysqlperformanceblog.com/2008/12/10/mysql-51-went-to-ga-was-it-a-good-move/" rel="nofollow noreferrer">was it a good move</a></p> <p><a href="http://feedblog.org/2008/12/04/destroying-mysql/" rel="nofollow noreferrer">destroying mysql</a></p> <p><a href="http://www.theregister.co.uk/2008/12/01/mysql_5_1_monty_rant/" rel="nofollow noreferrer">kick in the teeth</a></p> <p><a href="http://www.eweek.com/c/a/Database/MySQL-Founder-Urges-Cautious-Approach-to-MySQL-51/" rel="nofollow noreferrer">criticism</a></p> <p><a href="http://episteme.arstechnica.com/eve/forums/a/tpc/f/6330927813/m/377006385931" rel="nofollow noreferrer">random forum post</a></p> <p><a href="http://blogs.oracle.com/datacharmer/entry/what_s_going_on_in" rel="nofollow noreferrer">what's going on</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload