http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #4 from Paul Poulain <paul.poulain@biblibre.com> 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.