Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 787148" data-attributes="member: 82144">Hi and welcome JakeYou can use either MySQL or SQL Server. For those that prefer free (libre) open source software, the choice is obvious: MySQL. Otherwise I'd actually recommend SQL Server. It will perform better for you with MP not necessarily because it is a better DB engine, but because the DB abstraction layer that we use doesn't support MySQL as well as SQL Server. There is a higher query overhead on MySQL. In most cases you'd be unlikely to notice the difference, but if you have *lots* of channels (1000+) then you might notice channel list loading is faster with SQL Server.In my opinion this really is not necessary. The tuner driver, timeshifting/recording HDD speed, and OS HDD speed will *hands down* make the biggest difference to MP performance.My MySQL database is roughly 150 MB. If I were you I'd leave at least 0.5 GB if you insist on doing this.mm</blockquote>

[QUOTE="mm1352000, post: 787148, member: 82144"] Hi and welcome Jake You can use either MySQL or SQL Server. For those that prefer free (libre) open source software, the choice is obvious: MySQL. Otherwise I'd actually recommend SQL Server. It will perform better for you with MP not necessarily because it is a better DB engine, but because the DB abstraction layer that we use doesn't support MySQL as well as SQL Server. There is a higher query overhead on MySQL. In most cases you'd be unlikely to notice the difference, but if you have *lots* of channels (1000+) then you might notice channel list loading is faster with SQL Server. In my opinion this really is not necessary. The tuner driver, timeshifting/recording HDD speed, and OS HDD speed will *hands down* make the biggest difference to MP performance. My MySQL database is roughly 150 MB. If I were you I'd leave at least 0.5 GB if you insist on doing this. mm [/QUOTE]

Verification