[marcus_holmes]

sorry, I don't get this at all. How is using stored procs instead of an ORM going to adversely affect your cache strategy?

[keithnoizu]

Imagine for example that you have per record caches. You can run a query to get ids with out joining to the table and then simply fill in any gaps in your cache with a follow up query.