Thanks for your input, Sam. Here are some responses to your comments and questions.
1. MifOS does not use Hibernate caching today. 2. I agree that HashtableCacheProvider is not designed to be used in production. Although hibernate.properties does configure caching to use HashtableCacheProvider, no Hibernate mappings implement a caching policies. Thus it is not used today. Regarding caching needs: There are many alternative approaches to improving the performance of reports, including pre-building and caching reports, caching report data that is frequently accessed, and using the database's caching policies, if it has them. We will be analyzing the reporting module's usage scenarios to determine the best approach, which will be incorporated into a long-term report-architecture strategy. Keith Pierce On Jan 10, 2008 11:57 PM, Sam Lee <[EMAIL PROTECTED]> wrote: > On Hibernate Caching, > 1. In general (not 100% sure how MIFOS use it), hibernate cache is > typically okay for caching lookup operation, e.g., getting an office given > its id, but not so good for caching queries, typically not designed for > doing report type of queries either. > > 2. It smells a bit fishy that MIFOS use HashtableCacheProvider. Per > hibernate doc, it is not meant to be used for production. Maybe MIFOS > actually do not use it? > > http://www.hibernate.org/hib_docs/v3/reference/en/html/performance.html#performance-cache > > Back to your original problem, could you elaborate a bit more on your > needs? E.g., > 1. are you trying to cut down the response time of getting the same > report? Will caching of the actual report (pdf, html, or whatever) be > sufficient? > > 2. How customizable are the reports? Take an example, if it's a daily > report (that's basically the same) that take 1-hour to generate without > caching. Instead of caching (where the first person will need to wait > 1-hour), you actually might want to pursue the strategy of pre-generating > the report. > > > - sam > > On Jan 3, 2008 1:17 AM, Amiruddin Nagri <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > I was looking into caching in MIFOS. > > > > Currently MIFOS uses HashtableCacheProvider class for caching > > (configured in hibernate.properties). Can someone shed some light on how > > it is being used ? > > > > I was planning to use ehacache with hibernate as it gives more options > > (and is the default choice in hibernate). > > > > Will it be possible to move to ehcache from HashtableCacheProvider ? > > > > Any help/comments/suggestions appreciated. > > > > Amiruddin Nagri, > > Bangalore, 560008, KA > > India > > > > Y! IM : [EMAIL PROTECTED] > > GTalk : [EMAIL PROTECTED] > > > > > > > > *Amiruddin Nagri <[EMAIL PROTECTED]>* > > Sent by: [EMAIL PROTECTED] > > > > 01/03/2008 12:19 PM > > Please respond to > > Developer <[email protected]> > > > > To > > [email protected] cc > > Subject > > [Mifos-developer] Caching Strategy in MIFOS > > > > > > > > > > > > Hi, > > > > I am working on report module of MIFOS. I wanted to know what is the > > caching tools/strategies used in MIFOS application. > > > > So if there is a possibility of re-using the caching framework in MIFOS, > > I can make the most use of it. > > > > There is ehcache-1.2.3.jar present in MIFOS is not being used, probably > > some other(probably hibernate) libraries have dependencies on it. > > > > I am not sure about caching at Hibernate level as it will have affect > > application wide. > > > > Any suggestions/comments are most welcome. > > > > > > Regards, > > > > Amiruddin Nagri, > > Bangalore, 560008, KA > > India > > > > Y! IM : [EMAIL PROTECTED] > > GTalk : [EMAIL PROTECTED] > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace >
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
