[
http://mifosforge.jira.com/browse/MIFOS-4937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Monsen resolved MIFOS-4937.
--------------------------------
Resolution: Fixed
Assignee: Udai Gupta (was: mifosdeveloperqueue)
Between the 2nd-level caching we've implemented and the fix for MIFOS-4949, I
think we're done with caching for now.
Performance tests (like what SunGard was doing) and [specific
analyses|http://thread.gmane.org/gmane.comp.finance.mifos.devel/11522] would
tell us if more caching is necessary.
> cache most common queries/entities using hibernate 2nd-level cache
> ------------------------------------------------------------------
>
> Key: MIFOS-4937
> URL: http://mifosforge.jira.com/browse/MIFOS-4937
> Project: mifos
> Issue Type: Improvement
> Components: Navigation and UI
> Affects Versions: Release G
> Reporter: Adam Monsen
> Assignee: Udai Gupta
> Priority: Major
> Labels: volunteer
> Fix For: Release G - Iteration 6, Release G
>
>
> Cache select queries/entites using the hibernate 2nd-level cache, with the
> goal of eliminating superfluous, chatty database traffic on most page hits.
> * watch the mysql query log while clicking around in Mifos or use hibernate
> statistics to identify entities and queries that should be cached
> * for instance: look for repeated fetches of the same rows of small tables
> ** likely candidates: roles_activity, lookup_value_locale, lookup_entity
> ** unlikely candidates: account_trxn, loan_schedule
> * aim for big wins with small changes
> * choose *just a few* tables
> * modify the hibernate configuration (either XML or annotations) so that
> relevant entities and/or queries are cached
> * measure the number of fetches to these tables before and after enabling
> caching
> * show/document/demonstrate the effect of your changes
> Discussion: http://thread.gmane.org/gmane.comp.finance.mifos.devel/11469
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
