Views and L2 Cache

Thread is closed for posting
2 posts, 0 answers
  1. Ryan
    Ryan avatar
    8 posts
    Member since:
    Jun 2012

    Posted 03 Dec 2014 Link to this post

    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,

  2. Thomas
    Thomas avatar
    590 posts

    Posted 04 Dec 2014 Link to this post

    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.

    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
Back to Top