10 reasons why I chose MySQL over MSSQL2005 Express

home
database
view story

38 Kicks

Kick It

Drop Kick

Kicked

10 reasons why I chose MySQL over MSSQL2005 Express(blogs.aspcode.net)

submitted by aspcode.net(1045) 4 years, 1 month ago

10 reasons why to choose MySQL as database engine for your websites instead of MSSQL 2005

6 comments |category: Database |Views: 39
Tweet

tags: mssql MySQL Database another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

adventurer(2244) -

drewnoakes(0) -

ercu(15) -

jasper22(1320)

More who kicked this story...

Comments:

posted by spirit1(3160) 4 years, 1 month ago 0

in express you can easily achieve this with row_number function.

posted by jf26028(635) 4 years, 1 month ago 0

row_number is not near as easy to use as limit. Either from an orm or generated script perspective.

posted by rev4bart(420) 4 years, 1 month ago 0

The ranking functions combined that top now can take a dynamic parameter helps a lot.

Some of the read/shared locks can also be eliminated from SQL Server by doing interesting things.

I think for a small web app and smaller databases, MySQL might be a good choice. If you want to grow this into anything bigger and use any MS add-ons ur going to be sorry for making that decision down the line.

posted by tallen(130) 4 years, 1 month ago 0

Could you not accomplish the same thing as LIMIT 10 with TOP 10 (presuming you use the same order clause)?

http://authors.aspalliance.com/stevesmith/articles/sprowcount.asp

posted by hgarcia(1534) 4 years, 1 month ago 0

The usage of LIMIT has always been a big attraction for me as well.It makes everything so easy in doing paging, no need to define a page size or anything like that, just pass two numbers at the end of the query and you are ready to go. Speed (if you just need read) is as well a very good argument.
LIMIT It's not the same as using TOP 10 That gives you just the first ten results but them you will need the results from 11 to 20 and 21 to 30 etc. There is a way of using top and subqueries to filter the results and achieve a similar result but in that case use pages, it's better.

posted by rgelb(245) 4 years, 1 month ago 0

I agree, that LIMIT takes the cake, but it has issues namely it's crippled use inside of stored procedures. In addition MySQL has a lot of other issues, documented here: http://www.angryhacker.com/blog/archive/2007/09/16/mysql-eye-for-an-microsoft-sql-server-guy.aspx

Most Active Users

What's this?