Re: performance on new linux box

On 07/11/2010 03:02 PM, Ryan Wexler wrote:

>
> Well I got me a new raid card, MegaRAID 8708EM2, fully equipped with
> BBU and read and write caching are enabled.  It completely solved my
> performance problems.  Now everything is way faster than the previous
> server.  Thanks for all the help everyone.
>
> One question I do have is this card has a setting called Read Policy
> which apparently helps with sequentially reads.  Do you think that is
> something I should enable?
>
>
>

I would think it depends on your usage.  If you use clustered indexes (and understand how/when they help) then enabling
itwould help (cuz clustered is assuming sequential reads). 

or if you seq scan a table, it might help (as long as the table is stored relatively close together).

But if you have a big db, that doesnt fit into cache, and you bounce all over the place doing seeks, I doubt it'll
help.

-Andy