[
http://mifosforge.jira.com/browse/MIFOS-4937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=66981#comment-66981
]
Adam Monsen commented on MIFOS-4937:
------------------------------------
See also: [why LookUpEntity isn't
cached|http://thread.gmane.org/gmane.comp.finance.mifos.devel/11521/focus=11523]
(but note Van's comment on MIFOS-4949, all this stuff goes away eventually)
> 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
