http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828
--- Comment #4 from Paul Poulain <[email protected]> 2011-09-01 15:11:55 UTC --- > > Other suggestion : this kind of dashboard, appearing on homepage, can be > > highly > > CPU consuming for large databases. I strongly suggest to cache the result > > in a > > file and update the dashboard only once every night. > > Yes, we have been toying with this idea too. At the moment, the number of > selects is increasing and although they are only counts* it isn't ideal to > have > those queries running directly with every main page load. The only downside we > had to this is that it introduces another cron job and makes the data somewhat > stale (until updated at night). Is this the general consensus? Generate a > static page nightly? Well, the static is definetly better if you want it on homepage ! But, depending on how deep you want to go, you can also : * have a button "update" available only for patrons with a (newly created) permission. That would result in semi-static stats : the boss can update, it's not updated everytime the page is loaded * you could use memcache for results also : if memcache is set, the retrieve the result from memcache. If it's not set, calculate everytime In fact, there are many possibilities ;-) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
