| Author |
 Topic  |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
 Posted - 25 September 2004 : 09:28:39
|
Myself and another guy are running an online gamer;s forum but recently we decided to use a more modded snitz forum. However someone pointed out that Access won't be suitable for the new heavily Modded forum and to use SQL.
So my query is, what is the difference between SQL & MySQL? And when searching for a host, are there any certain things I need to look out for or be aware of? The best deal I've seen so far is here - onsmart.net.
Thanks  |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 25 September 2004 : 11:57:13
|
Price really, is the main difference. Both platforms offer a lot (IMO, MSSQL offers more) but it all comes down to price and personal opinion. Don't go for ultra cheap hosting, because you really do get what you pay for...I've been down that road. Generally a lot of hosts that offer MySQL, offer that with linux hosting, which isn't best suited for running snitz. You'll most likely going to find a windows host which offers MSSQL. Also, I can see a lot of FREE MSSQL hosting in the near future with the release of SQL Server 2005 Express. At least I know my company will be doing this.
Still, MySQL doesn't do everything MSSQL does, but if you don't need those features yet, then you don't need them. Syntax wise, they differ slightly in some aspects, usually when you get to more complicated joins. |
Erick
Snowmobile Fanatics
|
 |
|
|
-gary
Development Team Member
406 Posts |
Posted - 25 September 2004 : 15:49:42
|
There's a post somewhere here by me that I tested MSSQL and MySQL against each other on a 170,000 post database. MSSQL returned twice as fast as MySQL easily and sometimes 5 or 6 times faster. This was all on Win2K running on a local machine. I neveer did test MySQL on a seperate machine on Linux. Might be faster, but I still doubt it. What will be interesting is when SQL 2005 lets you used shared memory to communicate instead of IP.
But MySQL hosting will almost always be cheaper than MSSQL due to the licensing costs. Oddly though, I usually see that MSSQL is only $2 or $3 a month more on a lot of hosts. |
KawiForums.com
 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 25 September 2004 : 19:49:00
|
Not to be picky, but SQL is a database programming language, and MySQL is a DBMS product. :)
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 25 September 2004 : 23:27:02
|
| LOL @ Doug, glad to see it's not only me that shudders when reading things like this |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 26 September 2004 : 12:43:33
|
| I shudder when someone calls it DBMS and not RDBMS. Lighten up. |
KawiForums.com
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 September 2004 : 15:00:37
|
Shudder away.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 26 September 2004 : 17:12:49
|
| -gary, you've got nothing to worry about then, you obviously know the difference. Personally I prefer my MDBMS, but a SQL based RDBMS is the next choice They are all DBMS's though |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 September 2004 : 19:56:23
|
Occasionally, I do try to correct misuse of "SQL" referring to Microsoft SQL Server. Generally on this forum the meaning is pretty obvious, but if you go to a Sybase forum and start talking about SQL Server even you'll have communication problems. And if you go to a general db form pretty universally the term "SQL" refers to the SQL language, not a DBMS product.
And for those readers who don't know, these are some common generic acronyms in the DB world:
DBMS = Database Management System
RDBMS = Relational Database Management System
OODBMS = Object Oriented Database Management System.
MDBMS - Laser will have to jump in 
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 September 2004 : 21:32:48
|
| M = Multidimensional |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
seahorse
Senior Member
USA
1075 Posts |
Posted - 26 September 2004 : 21:47:14
|
quote:
Originally posted by Gremlin
M = Multidimensional
Multidimensional = OLAP Cube? |
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 September 2004 : 21:58:41
|
Cube yes, OLAP not always. Multidimensional data is represented as cubes. OLAP on the other hand is online analytical processing (or something like that) .. generally something that goes hand and hand with large data warehouses, but the underlying database doesn't necessarily have to be a multidimensional one.
That then starts a whole nother topic ... ROLAP, HOLAP, MOLAP, DOLAP. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 27 September 2004 : 01:32:33
|
ROFL .... goodonya Gremlin , and you're right too.
RDBMS - data is stored relationally (the usual tables and indexes that everyone here knows and loves).
MDBMS - data is stored multidimensionally.
We usually do called it OLAP (OnLine Analytical Processing), as opposed to OLTP (OnLine Transaction Processing) which is really where the differences lie. I've used Oracle Express for over 10yrs, Express is great for analysing huge quantities of data, it you couldn't use it for a forum because it only supports one session writing to the database at any one time. In a transaction system that would be suicide but in a proper OLAP system you are analysing the data, with very little data entry - moreso the data is loaded from file on a nightly, weekly or monthly process. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 27 September 2004 : 05:37:56
|
Back to the differences between MS SQL Server and MySQL - yes, price is one, performance is undoubtedly another, and featureset completes the trio.
The following are supported by MS SQL 2003, not by mysql 4.1 (only comparator i could find details for)
SQL VIEW support
Triggers
Stored Procedures
User Defined Functions
CURSOR Support
XML Support
FULL JOIN
Transaction Support (avail in MySQL with InnoDB, apparently)
Auto Tuning
Job Scheduling
Profiling
Log Shipping
SAN support
OLAP Services
MSSQL also has better Replication support and import/export support I gather, especially using DTS, and Hot/Incremental backups, plus more stuff.
hth
|
|
|
|
Tiggerz
Starting Member
45 Posts |
Posted - 27 September 2004 : 07:16:29
|
I shudder when people call it RDBMS/DBMS or anything else :)
SQL stands from Structured Query Language and is a programming language for data based systems (not always relational).
RDBMS stands for Relational Database Management System and is a piece of software that handles data stored in table based form.
DBMS is short for Database Management System and means any type of data store :)
MySql does some basic database stuff fairly well but beyond that is fairly limited in functionality. Its not exactly scaleable and is lacking many features of a true DBMS (such as oracle, DB2 and SQLServer). It would be fine for a forum environment - its unlikely you would get a big enough load to make it struggle. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 27 September 2004 : 18:58:10
|
quote:
I shudder when people call it RDBMS/DBMS or anything else :)
What "it" are you referring to?
MySQL is quite scaleable (within reason anyway). Many very large db's use MySQL, and MySQL is certainly a "true" DBMS.
V5 includes views, sp's and more.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
