MS SQL Vs. MY SQL
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25568
Printed Date: 28 March 2026 at 9:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MS SQL Vs. MY SQL
Posted By: gupta_ji
Subject: MS SQL Vs. MY SQL
Date Posted: 08 April 2008 at 5:09pm
|
I am making a networking website that will have huge database and lot of persons may be accessing at one time. Can you tell me which one will be good, will mysql will be OK, as I m currently using this. ------------- http://www.sgrj.com" rel="nofollow - chartered accountants India , http://www.delhiprofessionals.com" rel="nofollow - accounting Outsourcing ISO Certification |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 08 April 2008 at 5:53pm
|
Both databases are very good it all depends what you are going to be using it with and what resources you have available. If you are using ASP or ASP.NET I would use SQL Server as it works very well and can handle many 1,000's of simultnious connections, but SQL Server is very memory intensive so you need allot of memory in the database server, at least 1Gig. mySQL is a very good database and less memory intensive that SQL Server but more disk I/O intensive, so you need to make sure you are using fast hard disks. mySQL is let down when being used with ASP or ASP.NET as the myODBC driver is horrible and buggy, so if using these I would use SQL Server instead. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: gupta_ji
Date Posted: 09 April 2008 at 12:15pm
|
Thanks for the reply, I am using PHP for my website. Will that be ok with mysql. ------------- http://www.sgrj.com" rel="nofollow - chartered accountants India , http://www.delhiprofessionals.com" rel="nofollow - accounting Outsourcing ISO Certification |
Posted By: WebWiz-Bruce
Date Posted: 09 April 2008 at 3:48pm
|
If you are using PHP then you would use mySQL.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: alemcherry
Date Posted: 01 October 2008 at 3:46pm
MySql will be more than ok. Yes, it lacks some of the enterprice features of SQL server, but MySQL server is a pretty good database. If it is going to be enough for yahoo, should be more than enough for you :) |
gupta_ji wrote: