This question is locked. New answers and comments are not allowed.
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
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
1 Answer, 1 is accepted
0
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
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
OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.