I may be shooting around in the dark here... mainly because I don't know all that much about cahing tables in memory... But I would think that since RAM reads, writes, and performs much faster than hard drives that putting a table in RAM, if you have the space, would be a great idea... I mean what would be the downfall of doing this? Other then of course power failure... because that would be... well... problematic...

I have a little over a gig of RAM on my personal PC at work... it's an AMD Athlon 900 Mhz... I was curioius if I could create a temporary RAM drive and trick windows into using it as it's temporary swap file... to take the load off my hard drive... I've noticed a speed increase of about 45% across the board... so I would imagine the same would hold true for a table that was moved to RAM?