Forums
This topic is locked
The free world vs MS
Posted 14 May 2002 10:21:19
1
has voted
14 May 2002 10:21:19 Julio Taylor posted:
what are the advantages (if any) of the fourth reich's MSQL Server vs. MySQL? Are there any performance issues?How do they compare with Oracle's offering of the system?
P.S. i killed kenny
Replies
Replied 14 May 2002 13:39:54
14 May 2002 13:39:54 Owen Eastwick replied:
Well, first off I have to say, monopoly issues aside, that I'm quite a fan of a few of Heir Gate's products.
No one in a dark suit and shades or an SS uniform has ever strongarmed me and forced me to use them - yet. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
Performancewise MS SQL does quite well compared to the competition:
www.tpc.org/tpcc/results/tpcc_perf_results.asp?resulttype=all&version=5
Featurewise, there are some things you can do in MS SQL (and Oracle - I think) that are not possible in MySQL.
MySQL doesn't support:
Subqueries
Stored Views
Stored procedures
Triggers
If you don't know what they are and haven't used them - you won't miss them, if you do and you have - you will.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
No one in a dark suit and shades or an SS uniform has ever strongarmed me and forced me to use them - yet. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
Performancewise MS SQL does quite well compared to the competition:
www.tpc.org/tpcc/results/tpcc_perf_results.asp?resulttype=all&version=5
Featurewise, there are some things you can do in MS SQL (and Oracle - I think) that are not possible in MySQL.
MySQL doesn't support:
Subqueries
Stored Views
Stored procedures
Triggers
If you don't know what they are and haven't used them - you won't miss them, if you do and you have - you will.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo