[Koha-bugs] [Bug 6828] Add Admin Dashboard for staff users.

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828

--- Comment #4 from Paul Poulain <paul.poulain at 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.