MySQL v SQL Server
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11255
Printed Date: 31 March 2026 at 6:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL v SQL Server
Posted By: Amateur
Subject: MySQL v SQL Server
Date Posted: 22 July 2004 at 5:05am
|
Could someone explain the difference between the following, 100 MB MySQL Database and 50MB SQL Server 2000. My host offers both packages. Also i use web wiz forums and was wondering if the SQL version would run on 100 MB MySQL Database? |
Replies:
Posted By: Mart
Date Posted: 22 July 2004 at 5:31am
|
WWF will not run on MYSQL server, however it will run on MSSQL. MySQL does not support ASP aswell as MSSQL does. MySQL is considered faster but it has less features and no support for Stored Procedures. If you use ASP you should really go for MSSQL, if you use PHP then go for MySQL as PHP has built in support for MySQL. |
Posted By: Amateur
Date Posted: 22 July 2004 at 5:36am
| I use all ASP so it looks like MSSQL. Any ideas if WWF will be released to run on MySQL in the bear future or any plans to do so? |
Posted By: michael
Date Posted: 22 July 2004 at 1:31pm
|
Please do a search regarding MySQL, this has been answered plenty of times. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: the boss
Date Posted: 24 July 2004 at 4:39am
|
suspend this thread!! ------------- http://www.web2messenger.com/theboss"> 
|
Posted By: zMaestro
Date Posted: 24 July 2004 at 6:59am
He is a new comer, give him help the boss.. you have 911 posts
|
Posted By: Bluefrog
Date Posted: 24 July 2004 at 10:28am
|
On the help side... MySQL will work very well with ASP. That is not a problem. MySQL being faster... not sure with the current build... But I doubt it. MySQL has traditionally been used heavily for web applications, where MSSQL has been used for all manner of DB applications, online and offline. MYSQL being a real RDBMS... I've heard that it's been upgraded, but dont' really care to look into the specifics at the moment. That could be false. MSSQL is a true RDBMS, which guarantees that your data will be referentially intact if you practise decent design. I'd go for MSSQL because it is well supported, documented, reliable, and just nice to use. MySQL I find a bit obtuse and I absolutely hate the way it handles dates when used with ASP. Just my 2 cents.
------------- http://renegademinds.com/" rel="nofollow - Renegade Minds - Guitar Software http://renegademinds.com/Default.aspx?tabid=65" rel="nofollow - Slow Down Music |
Posted By: Amateur
Date Posted: 24 July 2004 at 10:44am
|
Thanks for the explanation Bluefrog and having the patience to explain it.
the boss >> |
the boss wrote:
Posted By: dpyers
Date Posted: 24 July 2004 at 12:14pm
|
You'll find many more data base examples for ASP that reference MSSQL instead of MySQL by a wide margin. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: zMaestro
Date Posted: 24 July 2004 at 5:14pm
|
the boss was joking.... the problem is... there was a problem here before because moderators had to reply to the same posts and same questions 100s of time, check this: http://forums.webwiz.net/forum_posts.asp?TID=11163&PN=2 - http://forums.webwiz.net/forum_posts.asp?TID=11 163&PN=2
|
Posted By: Bluefrog
Date Posted: 24 July 2004 at 8:55pm
Actually, as opposed to suspending the thread, it should be moved to the database discussion area. And, none of us really answered the question... The difference is disk storage. Many hosts offer fixed storage limits for files and fixed storage for databases. The main consideration that you mentioned would be whether you have an application that needs massive amounts of storage in the database (you can usually buy more).
------------- http://renegademinds.com/" rel="nofollow - Renegade Minds - Guitar Software http://renegademinds.com/Default.aspx?tabid=65" rel="nofollow - Slow Down Music |
Posted By: the boss
Date Posted: 25 July 2004 at 3:13am
|
Joined: 19 January 2003 ------------- http://www.web2messenger.com/theboss">
|
Posted By: the boss
Date Posted: 25 July 2004 at 3:24am
|
mssql is more industry adopted on windows plattform then mysql..it is more professionally designed to compete with others such as Oracle rather than open source child play mysql.. MYsql is infact a good product to use and learn databases but mysql and asp just dont go well hand in hand with eaqch other if u are using mssql, u can easily attach and deattach databases as well attach those u recovred from ur crashed server, etc etc ..as well many other facilities to import / export data and shedule services and stuff mssql has stored procedure facility.. a huge plus if u ask me where as mysql has no built in support for procedures..stored procedures show real glory when database servers recive high traffic on regular basis such as web wiz guide database... we are all discussin never ending thread here and still not reached to crashing the jodo host sql server ------------- http://www.web2messenger.com/theboss">
|