Hi
Is it true that MS SQL Server uses more memory than MySQL?
no
and could you please not start separate threads for all these oversimplified little questions?
you have at least one other thread going which compares database systems
Thank you. Look at this reply quoted from a web host:
“mySQL uses allot less memory, for example we have one SQL Server database with 100 databases and it uses 5GB or memory, we have also a mySQL database with also 100 databases which uses 300MB of memory.”
more memory = better throughput = faster response
you seem to be collecting all these little gems of wisdom… when are you actually going to sit down and build something?
Are those the exact same 100 databases running on both SQL server and MySQL? If not, the comparison doesn’t tell you anything.
It’s like saying: I’m running 100 programs on my Pentium 4 and 100 programs on my i7 and the Pentium 4 uses 10MB of memory and the i7 uses 10GB of memory, so the pentium 4 is waaaay better!
While in reality I’m running 100 instances of minesweeper on the Pentium 4 and 100 instances of Photoshop on the i7 …
Btw, since when is 300MB more than 5GB? Did I miss a memo?