Views and L2 Cache

I am having an interesting issue with a view.
We have a table (order) that has a large number of foreign keys and we connect them all together in a view (order_detail).
If we save changes to the order then query the order_detail view we cant see the updated record in the view until we evict the order_detail record from the L2 cache.


Thanks in advance for any help,

Ryan

Hi Ryan,

the problem with views in general is, that we have no way of detecting how they are constructed. Therefore we have no knowledge what views we need to evict when a table content changes.
So manual eviction is -at the moment- your only choice.

Regards,
Thomas
Telerik