Hi all- I first wanted to introduce myself to the community. I am a Technical Program Manager working on Mifos, and am responsible for reporting and i18n from the business side.
I thought it may be of interest to mention why Amiruddin is looking into caching. His research into caching is mostly for improving the performance of parameter drop-downs right now, not for the report data itself. In many reports, we want end-users to be able to be able to select hierarchical parameters such as branches/loan officers/centers. During testing we have found the population of the drop-downs to be very slow, on the order of 20 seconds in some cases. Although users can accept having report generation take some time, we want the parameter drop-downs to be populated as close to instantaneously as possible. In regards to caching actual report results we will likely be using some combination of scheduling performance-intensive reports to run in the evening, de-normalized reporting tables populated by batch jobs, and selectively caching report data, as Keith has mentioned. Thanks, Beth ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Pierce Sent: Friday, January 11, 2008 12:19 PM To: Developer Subject: Re: [Mifos-developer] Caching Strategy in MIFOS 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/marketp lace
------------------------------------------------------------------------- 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
