So we have a NST cache which will cache allot of frequent asked resultsets (based on cachesize)

and we have an SQL server that caches what it thinks is right.

These caches are very nice, but when you have a expensive calculation which involves allot of queries and allot of setup, its really nice to keep allot of those data that does not change that much but is needed in a single instance.. it speeds things up allot.

But webservice calls and odata Function calls do not actually benefit from this single instance way of your own cache.

it has to read for every single call all the data to make its expensive calculation based on allot of parameters

Or

needs to read a mapping table all te time

Or what about a expensive query to show something nice in the dashboard of every user..

such a wased.. of time and of filling the cache of SQL with this data instead of the actual data that i cannot predict to cache.

could we please have a possibility to put something in a cache at NST level

so we could choose to cache certain data for all users to perform faster, and webcalls etc.

I know MS has it somewhere on there list, but not as high priority. So please give a vote!!