[
http://mifosforge.jira.com/browse/MIFOS-4937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy updated MIFOS-4937:
--------------------------------
Status: Ready for Showcase (was: Ready for Testing / Resolved)
> 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
------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
