I was thinking that this would speed up cases where we routinely hit the database for lookup table values. (How)Can a person go ahead and do some caching that gets hit when prefetchpaths are used?

ie: I ask for customer and the state table lookup and state is cached somehow.. it ll would go to the cache rather than the db.

That subject is well explained here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15534&StartAtMessage=0&#86615

Also take a look at the article link inside that thread.

thanks. I had a somewhat difficult time looking through the search results on caching