Thats the way the query cache actually works, it is not *any* table, but a table that is used on the query. If you need a more sofisticated solution, please read this Fabio's post first:
http://fabiomaulo.blogspot.com/2009/04/tuning-nhibernate-tolerant-querycache.html 2011/1/7, Borges <[email protected]>: > Thanks again, Jose. > > I am trying to design a more efficient query cache. > > The current, standard query cache will invalidate a query if any table > has been changed. > > What I would like to do is this: > > Given an update to entity A: > > 0) store in-memory equivalent of HQL for each query (using LINQ to > objects, for example) > > 1) calculate all entities that are affected by the update; i.e. any > entity that has > a collection containing A, or has a reference to A. > > 2) run in-memory query on all affected entities, and re-cache the > results > > > Also, I need this to work with a distributed L2 cache. > > This is a lot of work! I am about 80% done. I had to fork NH to > support this new functionality. > > If I could use the cascade infrastructure to generate a list of > affected entities, that would > be very helpful. > > Thanks again. > > > > On Jan 7, 12:45 pm, José F. Romaniello <[email protected]> wrote: >> nhibernate has a powerful cascade infrastructure.. would you mind to >> expand >> your problem to see if we can help you? >> It can delete, update persist , anything on cascade it is very powerful. >> >> 2011/1/7 Borges <[email protected]> >> >> >> >> >> >> >> >> > Thanks, Jose. My problem is: given an entity update, calculate what >> > other entities >> > are affected by the update. >> >> > On Jan 7, 5:54 am, José F. Romaniello <[email protected]> wrote: >> > > I don't know why you would need to do that, but i think you can start >> > > to >> > > play with the nhibernate metadata in session factory configuration.. >> > > Just >> > > run the debugger and see what is going on there >> >> > > 2011/1/6 Borges <[email protected]> >> >> > > > Hello, >> > > > Does NH store an object graph for all of its mappings? What I mean >> > > > is, >> > > > given an entity, >> > > > is it possible to calculate *all* NH entities that reference this >> > > > entity? >> >> > > > i.e. given entities A,B,C,D, with >> >> > > > A <>--------> B <>-----------> C <>------------> D >> >> > > > (where <>---------> indicates aggregation) >> >> > > > if I am presented with an entity of type D, can I generate A,B and C >> > > > from NH? >> >> > > > Thanks, >> > > > JL Borges >> >> > > > -- >> > > > You received this message because you are subscribed to the Google >> > Groups >> > > > "nhusers" group. >> > > > To post to this group, send email to [email protected]. >> > > > To unsubscribe from this group, send email to >> > > > [email protected]<nhusers%[email protected] >> > > > > >> > <nhusers%[email protected]<nhusers%252bunsubscr...@googlegroup >> > s.com>> >> > > > . >> > > > For more options, visit this group at >> > > >http://groups.google.com/group/nhusers?hl=en. >> >> > -- >> > You received this message because you are subscribed to the Google >> > Groups >> > "nhusers" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]<nhusers%[email protected] >> > > >> > . >> > For more options, visit this group at >> >http://groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Enviado desde mi dispositivo móvil -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
