MySQL 5 vs MS SQL server 2005

[and-81]

Originally Posted by Shivian

I'm not saying to stay away from MS...

The "Anti-Microsoft" part wasn't directed at you

I was loathe to mention it because it can unfairly place people with genuine arguments into the same box as people who don't know anything about the differences but go with a gut feeling of anti-Microsoft sentiment.

I didn't mean to use it to belittle your position on the matter. I'm sorry if it seemed that it was directed at you.

Originally Posted by Shivian

I'm saying the Express edition has some limitations that are unnecessary and can limit performance when there is an alternative that doesn't not have such limits. If you are running dual or quad cores, why not let the database take advantage of that?

That may be true for large-scale database users, but in regards to MediaPortal, the whole database debate is a waste of time...

MediaPortal is not a "big" database user. MS SQL and MySQL are both more than up to the job and the differences between the two are utterly negligible in this context.

In the future (Read: MediaPortal 2) we will not be dividing our efforts by supporting multiple databases, in fact we'll be avoiding this issue completely. I'm not sure if I should say any more than that at this stage, I don't want to make statements about it without team approval, suffice to say that MS SQL versus MySQL will not be relevant ... eventually.

Cheers,

[allanp81]

How is MySQL's memory usage compared to MSSQL? I've noticed sometimes on my server that the MSSQL service is using a ridiculous amount of memory, somewhere in the region of 700meg!

[and-81]

The amount of memory that is reported in Task Manager is a bit misleading ... see here:

How much memory does my .NET application use? Explaining the Task Manager figure versus Private Bytes in performance monitor.

Comparing the memory working set is not a reliable measure of an applications impact on the system.

Cheers,

[tourettes]

MSSQL uses the huge amount of memory to optimize the queries. Not a bad thing, as otherwise your memory would most likely sit in the PC without doing anything. Just like disk cache.

If worried you can limit the MSSQL memory usage from it's settings.

[deebo]

id guess its upto preference and/or the different ways to setup it

i use mysql simply because ive used it alot, and my linux fileserver is running it anyhow for my web dev projects

no MS clutter on my htpc, just codecs and MP

[Shivian]

Originally Posted by allanp81

How is MySQL's memory usage compared to MSSQL? I've noticed sometimes on my server that the MSSQL service is using a ridiculous amount of memory, somewhere in the region of 700meg!

As the others have said, it does depend greatly on what it is using that memory for. i.e. the breakdown of that 700MB.

The core MySQL application uses very little... we have a server running a simple software update service and the MySQL server for it takes up 17MB. I don't have access to my HTPC atm but I'll post how much a MySQL server for a TV server takes when I get the chance.

[stoked]

I was thinking of trying to setup mysql on a remote linux host to see if my EPG, miniEPG would run faster. Also, Big_Kev's web interface guide query pins my CPU and seems to affect my multi-seat streaming. Sounds like it's probably not worth my time according to the devs.