Reply to thread

Message

<blockquote data-quote="Fallen Kell" data-source="post: 477719" data-attributes="member: 95902">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).</blockquote>

[QUOTE="Fallen Kell, post: 477719, member: 95902"] 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). [/QUOTE]

Verification