The wallet is always loaded entirely into RAM anyway, and only modified in small incremental ways, so a large cache shouldn't ever be needed. However, when BDB was still used for the block chain database, we did require large caches to speed up prevout lookups during block validation. That part is now in LevelDB anyway.