You can also choose for an out of process cache. On Mar 24, 2012 9:39 PM, "mr_miles" <[email protected]> wrote:
> Hi, > > I'm using nhibernate in a web service, to retrieve some fairly > complicated objects from the database. As activity has grown, I've > started using the level2 cache to keep performance up, as activity is > mostly read and very little write. > > However, if we ever have to restart the service, the level2 cache is > cleared, and performance is "bad" until it fills up enough to reach > the steady state again. This is because the objects being retrieved > are to all intents and purposes randomly chosen from a very large set, > so performance only becomes "good" once a large proportion of the > objects have been retrieved. > > I'm wondering, is it possible to pre-populate the underlying data > cache by bulk fetching the data from the database. For example, by > running one query at start up that reads in all the rows for a given > table in one go, rather than doing it per-object? > > (nb I'm quite new to nhibernate, so apologies if this doesn't make > sense - I got this far from docs and web tutorials) > > Thanks. > > -- > 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. > > -- 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.
