Yes, the effect of locality groups would be about the same in an in memory system. The only exception would be if you're not using locality groups and are fetching a particular column, the automatic seeking behavior of the column filtering iterator would be more efficient with in memory rfiles.
Adam On Sep 12, 2012 5:20 PM, "David Medinets" <[email protected]> wrote: > Why would locality groups be useful in an in-memory system? > > On Wed, Sep 12, 2012 at 4:53 PM, Adam Fuchs <[email protected]> wrote: > > Even if you are just using memory, minor and major compactions are > important > > to get compression, handle deletes, get sequential access (cache line > > efficiency), use iterators, and introduce locality groups. >
