 |
07-12-2006, 04:35 PM
|
|
SEO Junior
|
|
Join Date: Sep 2004
Posts: 29
|
|
|
MySql vs SQL Server
Hi there,
What is the best tool: mySql or MS SQL? Why?
Thanks!
|
07-13-2006, 07:45 AM
|
 |
SEO GUY Moderator
|
|
Join Date: May 2004
Location: In perpetual style
Posts: 3,305
|
|
|
You can accomplish the same with either, it's a matter of your server OS. MySQL is for Linux & MSSQL is for Windows.
|
07-13-2006, 08:40 AM
|
 |
SEO Junior
|
|
Join Date: Jun 2006
Posts: 22
|
|
There's a good article here
What are you developing? MySQL should fit your requirements. It can hold millions of records, it's fast, open source, and free. Plus if you're not managing your own server, MySQL hosting is cheap. Can't beat that! |
07-13-2006, 10:22 AM
|
|
SEO Junior
|
|
Join Date: Sep 2004
Posts: 29
|
|
|
Thanks for your help. The article was really good.
We already have a website using MS SQL. The application we are developing will have the basic db operations (read, write, delete), joins (I could not find anything on JOIN on the article, is this still an issue with MySql?), views and a couple of transactions. No triggers or stored procedures for now. And we are going to add a shopping cart (not sure if Miva or OsCommerce).
|
07-15-2006, 07:58 PM
|
 |
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621
|
|
SQL Server is much more powerful than MySQL, in many ways.
But, its probably overkill for the average person wanting to build/run a website.
By the sounds of what your planning to do, almost any database type would be fine - including MS Access.
 |
07-27-2006, 07:15 PM
|
|
SEO Junior and a half
|
|
Join Date: May 2006
Posts: 50
|
|
SQL Server is my fave server to use when Im coding asp.net
But mysql is alot easier and lighter and well ... free
__________________
Visit Web10 - Directory, Blog, SEO Forum
|
08-21-2006, 12:16 PM
|
|
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621
|
|
|
I thought I would add, that if your application is going to make use of XML or AJAX, MS SQL Server is likely to be a better option. mySQL has no support for XML.
|
12-04-2006, 01:49 AM
|
|
SEO Junior
|
|
Join Date: Dec 2006
Posts: 4
|
|
Mysql is faster
SqlServer is easier
Sqlserver is more expensive :-)
If money is a factor choose Mysql, for sure...
What about Oracle ? :-)
----
What What When |
12-04-2006, 02:34 AM
|
|
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621
|
|
|
SQL Server is much faster than MySQL, but it depends on whether or not you know what your doing in order to optimise yours pages, tables and indexes - and even your queries.
SQL Server 2005 Express edition is FREE.
|
|
| Thread Tools |
|
|
| Display Modes |
Rate This Thread |
 Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
