MS SQL or MySQL 5 (1 Viewer)

[vur]

TV-Server Version:
MediaPortal Version: 1.0.2.0
MediaPortal Skin: default
Windows Version: XP Home SP3
CPU Type: AMD 64X2 3800
HDD: WD 250 X 2 WD 750
Memory: 1G
Motherboard: Gigabyte GA-K8NF-9
Video Card: GeForce 6600 GV-NX66128DP
Video Card Driver: 182.06
Sound Card: Creative Audigy Value
Sound Card AC3: coax out
Sound Card Driver: 5.12.01.514
1. TV Card: Nebula DigiTV USB
1. TV Card Type: DVB-T
1. TV Card Driver: 504
2. TV Card: Leadtek DTV1000T
2. TV Card Type: DVB-T
2. TV Card Driver: 4.0.112.3218
3. TV Card: Leadtek W'fst DTV1000 S
3. TV Card Type: DVB-T
3. TV Card Driver: WinXPVista32 02/11/07
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case: Silverstone LC17B
Cooling: 3 standard fans + custom CPU duct
Power Supply: Antec Phanton 500
Remote: none
TV: Projector EPSON TW-3000
TV - HTPC Connection: Sub-D

The installation of MediaPortal involves choosing between MS SQL or MySQL.

Would someone expand on how to decide which one please? I looked up Wikipedia but it was beyond my understanding.

 

[Fallen Kell]

MS SQL and MySQL are both database software (so are Postgres and Oracle). The differences are probably too many to even list, but they are technical differences in terms database tablespace, types, etc., (in other words things you as an end user who will not be creating his own database, won't really care). The only things that matter to you in this case are ease of use, and overall system performance. Unfortunately, I don't have any performance numbers comparing MS SQL and MySQL for running the MediaPortal database schema. Personally, I prefer MySQL, but that is because I have been a MySQL Database Administrator for several years (on Unix and Linux platforms, but not under Windows).

I've been meaning to take a look at the MediaPortal schema/database engine/table structure for a while, but it is not on the top of my priority list (I have other issues to work out before digging into this). In general either should be fine. MS SQL will probably run a little better out of the box then MySQL, but MySQL can probably be tweaked to gain a decent amount of performance. But even that is moot, if the CPU/memory usage is a pittance (which it probably is for just storing dvd and tv show data, even if downloaded images are completely stored in the database, it will be a relatively small database when compared against what MySQL and MS SQL are capable of handling).

 

[Nil Einne]

MS SQL and MySQL are both database software (so are Postgres and Oracle). The differences are probably too many to even list, but they are technical differences in terms database tablespace, types, etc., (in other words things you as an end user who will not be creating his own database, won't really care). The only things that matter to you in this case are ease of use, and overall system performance. Unfortunately, I don't have any performance numbers comparing MS SQL and MySQL for running the MediaPortal database schema. Personally, I prefer MySQL, but that is because I have been a MySQL Database Administrator for several years (on Unix and Linux platforms, but not under Windows).

I've been meaning to take a look at the MediaPortal schema/database engine/table structure for a while, but it is not on the top of my priority list (I have other issues to work out before digging into this). In general either should be fine. MS SQL will probably run a little better out of the box then MySQL, but MySQL can probably be tweaked to gain a decent amount of performance. But even that is moot, if the CPU/memory usage is a pittance (which it probably is for just storing dvd and tv show data, even if downloaded images are completely stored in the database, it will be a relatively small database when compared against what MySQL and MS SQL are capable of handling).

Do you feel the answer is different if we're talking about an old and limited resource computer? E.g. Athlon XP with 512 mb RAM

 

[vur]

Regarding MP 1.1, infinityloop states

"•MySQL 5.1 is now the default SQL-Server on a fresh installation.
(you can still use your already present SQL-Server as this effects only systems where no SQL-Server is present)
Benefits compared to MS SQL-Server:

◦works nicely on Windows 7 RC1 32 and 64 bit
◦uses less system resources than MS SQL Server
◦much easier to deploy (automatic download/install of MS SQL 2008 is not possible on Windows 7)"

 

[Fallen Kell]

Well, looks like someone finally did the performance comparisons As I said, I personally prefer MySQL. It is a great database software.