Thanks, Jose. Yes, I meant tables used by the query. And yes, thanks, I've read Fabio's post; I need something different.
So, is it possible to use the cascade infrastructure to map out entities affected by an update? Kind Regards, JL Borges On Jan 7, 9:03 pm, José F. Romaniello <[email protected]> wrote: > 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-que... > > 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.
