It is easy using a cache.query_cache_factory adding a tenant-prefix to each region.
2009/10/26 Tuna Toksoz <[email protected]> > You can also depend your cache providers on the user specific stuff. > That some class should already be available in yourt code to put the > username into session or something, i don't think this is a problem, is it? > > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksoz > http://tunatoksoz.com > http://twitter.com/tehlike > > > > > On Tue, Oct 27, 2009 at 12:15 AM, Niclas Pehrsson <[email protected]>wrote: > >> >> It could be if DynamicConnectionProvider would use the WebSession >> variable to point out the databasename. >> Then DynamicConnectionProvider could use the WebSession to build the >> session with the right databaseconnectionstring. >> It will be kind of akward way to do it. Some class needs to be >> responsible to put the right databasename in a websession with the >> right key so the DynamicConnectionProvider can read it this isn't >> obvious, but maybe the only way to do it. >> >> Im thinking about using OpenSession(IDbConnection dbConnection), more >> visible. >> >> But I have something in my back head telling me that hasn't >> SessionFactory something to do with second level cache or something >> else that would make this a bad solution? >> >> On Oct 26, 10:53 pm, Tuna Toksoz <[email protected]> wrote: >> > Does that solve your problem? >> > >> > Tuna Toksöz >> > Eternal sunshine of the open source mind. >> > >> > >> http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike >> > >> > On Mon, Oct 26, 2009 at 11:51 PM, Tuna Toksoz <[email protected]> >> wrote: >> > > oh yeah >> > >> > >http://nhforge.org/wikis/howtonh/dynamically-change-user-info-in-conn. >> .. >> > >> > > Tuna Toksöz >> > > Eternal sunshine of the open source mind. >> > >> > >http://devlicio.us/blogs/tuna_toksoz >> > >http://tunatoksoz.com >> > >http://twitter.com/tehlike >> > >> > > On Mon, Oct 26, 2009 at 11:49 PM, Tuna Toksoz <[email protected]> >> wrote: >> > >> > >> I think He does but i couldn't remember the keywords. >> > >> > >> Tuna Toksöz >> > >> Eternal sunshine of the open source mind. >> > >> > >>http://devlicio.us/blogs/tuna_toksoz >> > >>http://tunatoksoz.com >> > >>http://twitter.com/tehlike >> > >> > >> On Mon, Oct 26, 2009 at 11:49 PM, Niclas Pehrsson < >> [email protected]>wrote: >> > >> > >>> It would be really nice if someone has a link to Fabio's solution, >> or >> > >>> maybe he has it on his blog? >> > >> > >>> On Oct 26, 10:40 pm, Tuna Toksoz <[email protected]> wrote: >> > >>> > Fabio has a better solution. I think it was implementing/extending >> > >> > >>> > NHibernate.Connection.DriverConnectionProvider >> > >> > >>> > thing. >> > >> > >>> > Tuna Toksöz >> > >>> > Eternal sunshine of the open source mind. >> > >> > >>> >> http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitt... >> > >> > >>> > On Mon, Oct 26, 2009 at 11:32 PM, Jason Dentler < >> > >>> [email protected]>wrote: >> > >> > >>> > > Niclas, >> > >> > >>> > > ISessionFactory.OpenSession accepts an IDbConnection. Using your >> > >>> favorite >> > >>> > > IoC framework, create a unit-of-work scoped connection to the >> > >>> specific >> > >>> > > customer's DB and pass it in to a single application-scoped >> session >> > >>> > > factory. I doubt this was the intended purpose, but it may work >> > >>> anyway. I >> > >>> > > would start there. >> > >> > >>> > > Thanks, >> > >>> > > Jason >> > >> > >>> > > On Mon, Oct 26, 2009 at 4:12 PM, Niclas Pehrsson < >> [email protected] >> > >>> >wrote: >> > >> > >>> > >> Hi I'm doing some research when using NHibernate with Multi >> tenancy, >> > >>> I >> > >>> > >> have choosen to start with multi databases to solve the tenancy >> > >>> > >> problem. One database per customer. We hope that our product >> will >> > >>> have >> > >>> > >> several thousands customers, this will mean several databases. >> > >> > >>> > >> Now say that we will host this product and let the login of the >> > >>> > >> customer decide which database to use for the user, then we >> need to >> > >>> > >> have thousands of SessionFactories in the server memory cause >> we >> > >>> don't >> > >>> > >> wanna build it each time a user requests for it. >> > >>> > >> This will take a lot of memory, and some performance for the >> > >>> > >> sessionfactory lookup, that has been a common solution to solve >> this >> > >>> > >> problem by the research I have seen so far. >> > >> > >>> > >> So is thousands of loaded sessionfactories a problem? or will >> it be >> > >>> > >> fine? >> > >> > >>> > >> Can a custom like implementation of a garbage collection be >> used >> > >>> that >> > >>> > >> throws out sessionfactories that hasn't been used for a time >> solve >> > >>> > >> this problem? >> >> > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
