>>> Scott Carey <scott(at)richrelevance(dot)com> wrote:
> Set swappiness to 0 or 1.
We recently converted all 72 remote county databases from 8.2.5 to
8.3.4. In preparation we ran a test conversion of a large county over
and over with different settings to see what got us the best
performance. Setting swappiness below the default degraded
performance for us in those tests for identical data, same hardware,
no other changes.
Our best guess is that code which really wasn't getting called got
swapped out leaving more space in the OS cache, but that's just a
guess. Of course, I'm sure people would not be recommending it if
they hadn't done their own benchmarks to confirm that this setting
actually improved things in their environments, so the lesson here is
to test for your environment when possible.
-Kevin