[
http://mifosforge.jira.com/browse/MIFOS-4937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOS-4937:
----------------------------
Status: Ready to Ship / Verified (was: Ready for Showcase)
> 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
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense..
http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________
Mifos-issues mailing list
Mifos-issues@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues
