Re: Why does SQL express 2005 take so much RAM?

Have you checked your requests are not creating duplicate temp tables.
(order of Aliased Tables matter in every part of statements, Inner / Outer
Joins). etc.

ms sql --vs -- mysql

If only that was true

We have both ms sql server & mysql acting as large warehouses for highly
optimized Web-based calculation servers.
Some requests extract 100'000's of points (prices, time series data,
volatilities, correlations).

mysql beats mssql hands up.Ram or Not, (Yes UX swaps disk if you don't have
enough RAM!, but even that can be configured in mysql). mysql if MUCH more
efficient in terms of computer resources and speed. (in some specific
instances one order of magnitude!).

On the other hand ms sql beats mysql in terms of user friendliness, stored
procedures .. and views


BRgrds
John


<dbahooker@xxxxxxxxxxx> wrote in message
news:1126805915.501469.51450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> ms sql server kicks *** go out and buy some more memory
>
> sql server actually uses ram, mysql relies on disk too much
>


.