IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Re: MySQL is better than MSSQL..

Again, I don’t want to mislead you into thinking MySQL has more features than SQL Server because the truth is it doesn’t. But the features and capabilities MySQL does possess is usually more than enough to handle systems that need a strong OLTP or analytical database. But also understand that, although both SQL Server and MySQL have complementary features in many areas, there are sections where the depth of what SQL Server offers is better than MySQL. For example, both MySQL and SQL Server have GIS features, but SQL Server’s is more robust than MySQL’s. Ditto when it comes to their job scheduler vs. ours. But conversely, there are cases when MySQL rises above SQL Server in some ways, such as partitioning – SQL Server does have parallel support for partitioning, but MySQL provides more options for various types of partitioning: MySQL offers range, hash, key, list, and composite partitioning whereas SQL Server only offers range. And continuing with the example of partitioning, I find MySQL’s partitioning much easier to use as it’s defined right with the table via DDL during creation time vs. creating partitioning objects in SQL Server (partition schemes and functions) that are then applied to tables.

Of course, there are features in SQL Server MySQL has no complement for. Security is one particular area where MySQL trails Microsoft – unlike SQL Server, MySQL has no concept of roles or external authentication, and its data auditing abilities are quite weak compared to Microsoft. I could list many more features that SQL Server has over MySQL (e.g. better query optimizations and methods, transparent data encryption, etc.), but as I said earlier, MySQL isn’t about going all out with Microsoft or anyone else in the features arena.



From the sidebar:


Robin Schumacher is MySQL's Director of Product Management and has over 13 years of database experience in DB2, MySQL, Oracle, SQL Server and other database engines.





http://dev.mysql.com...t_SQL_Server.html




"Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from."

-- E.L. Doctorow
New CORE ONLY MySQL vs MS-SQL Complete.
That is the catch there.

I use it daily for Enterprise usage and class of service.

For comparison, our product competes directly in TPS with MS-SQL products. We have 10% the hardware requirements and about 1% the Software cost on the server-side.

Yeah... MS-SQL works great on Windows. That brings along the costs of the Windows Licenses and the enhanced Hardware requirements. FYI, former customers that have switched to competitors have to spend $100K per server (up to 5 needed for number of operators) to get the TPS we have using our hosted services.

All I can say is that one former customer in particular has drank the MS Kool Aid has spent well of $500K on just the server side hardware to get the performance they got with our stuff. Not to mention they've had to upgrade *ALL* computers that were running WindowsXP and Windows98. They had VERY few Windows Vista or Windows 7 machines. Oh and new versions of Office were required... plus they had to purchase the MS-SQL licenses and many other pieces parets MS doesn't include.

Sorry. That article you posted... I don't think you read it completely.
--
greg@gregfolkert.net
PGP key 1024D/B524687C 2003-08-05
Fingerprint: E1D3 E3D7 5850 957E FED0 2B3A ED66 6971 B524 687C
     Charlie D: Microsoft has failed. - (Another Scott) - (22)
         somewhere in the world dos 3.3 lives! - (boxley) - (3)
             More words, please. -NT - (Another Scott) - (1)
                 comparing MS to IBM - (boxley)
             yeah, those 440,000 employees, - (lincoln)
         sounds like it was written by a 21 year old - (lincoln) - (15)
             Charlie's been around a long time. - (Another Scott)
             You cannot be serious. - (mmoffitt) - (7)
                 MySQL is better than MSSQL.. - (folkert) - (6)
                     Okay, maybe that was a little unfair and ... - (mmoffitt) - (1)
                         No Problem there... - (folkert)
                     Re: MySQL is better than MSSQL.. - (lincoln) - (1)
                         CORE ONLY MySQL vs MS-SQL Complete. - (folkert)
                     Shirley you mean MariaDB? >:-) -NT - (scoenye) - (1)
                         Re: Shirley you mean MariaDB? >:-) - (folkert)
             Re: sounds like it was written by a 21 year old - (jay) - (5)
                 Re: sounds like it was written by a 21 year old - (lincoln) - (4)
                     Yes, but - (jay) - (3)
                         On Halo... - (folkert) - (2)
                             It was also an attack against fragmentation. - (static) - (1)
                                 Bloody Valve. - (pwhysall)
         SJVN quotes Goldman Sachs report. - (Another Scott) - (1)
             That is often overlooked. - (static)

Yeah, God forbid it should be your Mom.
80 ms