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.
