![]() ![]() Language for relational database management systems. Don't know what MS SQL server needs to do for hours while MySQL zip file can be unzipped and two line command can configure it within minutes.SQL is used to communicate with a database, it is the standard Just one another point, it takes only a few minutes to install MySQL while it takes forever to install MS SQL server on a new computer. We really like easily configurable events in MySQL in addition to it being free. Our own benchmarks, MySQL is performing better than MS SQL server. Pure stupidity to throw that money out for nothing. MS SQL server costs $3000 per two core (in our setup this would come out to be in six figures). Did I mention, no money even when running on a 32 core server and having five replication server. Replication is easy to setup and works like a charm. No licensing cost and MySQL is highly configurable, small foot print, performance better than MS SQL servers. Net app six months ago after getting tired with over $50K licensing cost for MS SQL server and this was the best decision ever. We switched to MySQL for our high profile financial. With MySQL 5.7.20 now, there is no reason to use MS SQL Server or any other commercial licensed database. I would much sooner deal with a product that says "don't do this because this is beyond our limits" than one that says "our product is the cure for cancer" and it turns out it couldn't cure a simple hangover! Ultimately this does inspire confidence in using the product because you know exactly what to expect. If you are used to some of the big vendors sales tactics this comes as a massive shock. They say exactly what the strengths and weaknesses are. The Sun/MySQL guys are remarkably honest about their product. That said, it has a large number of useful features that are very useful to web developers. No CHECK constraints, no index views, no separation of clustered indexes from primary keys. There are quite a few ommissions in MySQL that will trap a SQL Server developer. ![]() Where MySQL scores highly is that it is so cheap that it makes a scale-out design feasible, in which case the raw power of an individual box simply doesn't matter. ![]() If you look at the fanfare surrounding MySQL 5.4 it says "now supports more than 4 processors". That is fine if all you need is the performance of SQL Server 7.0Īt the enterprise level is simply doesn't compete. I've done extensive testing of MySQL and would say that in terms of performance it is about at SQL Server 7.0 level. So far no-one knows what Oracle is going to do to MySQL, not even Oracle. I hope we get some people with FU money who don't care about profits who create some products like MySQL used to be. I absolutely do not judge them for selling to SUNW - work is naturally profit driven. I hope the founders of the original company try a new endeavor. It's sad to see MySQL transform from something you cheer to something you pity. So basically, we have a bunch of SQL Server fans (albeit open-minded) on stackoverflow. And for gurus, they will use PostgresSQL. It seems that for db simpletons like me, SQL Server Express is easier to setup and use and is faster and more stable. The Agent issue is a nice to have, but not critical as you can work around it. I find that the size limit is not a concern because by the time the db gets close to that size, the application should either be profitable (and you buy the license), or you should kill the product. The only significant limitations on SQL Server Express are the 4GB db size and the lack of Agent. First, I do not like Sun and second, SQL Server Express is significantly more robust and 'Enterprise' than MySQL. I now use SQL Server Express instead of MySQL for just about everything. ![]() I credit the original MySQL team for the existence SQL Server Express. I have fond feelings for MySQL and their being able to compete with Oracle and SQL Server. I whole heartedly embraced MySQL when it first came out as I used to be a poor developer and all the RDBMs were too expensive. Did the recent purchase of MySQL by Sun and the subsequent buggy releases kill the MySQL brand? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |