[Building Sakai] Stats Tool
David Horwitz
david.horwitz at uct.ac.za
Thu May 9 00:26:03 PDT 2013
That's correct
D
On Thu, 2013-05-09 at 09:12 +0200, Nguni Phakela wrote:
Hi David,
Thank you for the reply. So that means the stats will still be accurate even with the daily cleaning of the SAKAI_SESSION and SAKAI_EVENTS table?
Cheers,
Nguni
On Wed, May 8, 2013 at 12:40 PM, David Horwitz <david.horwitz at uct.ac.za<mailto:david.horwitz at uct.ac.za>> wrote:
Hi,
The sitestats tool takes the events from those 2 tables and agreagates them in in its own tables. So yes I would advise daily cleaning of SAKAI_SESSION & SAKAI_EVENTS but this has no effect on sitestats
D
On Wed, 2013-05-08 at 11:31 +0200, Nguni Phakela wrote:
Dear All,
We have been having issues with the stats tool. The database records grow very fast with the events being logged in the SAKAI_EVENTS table and the SAKAI_SESSION table. So we have been doing a cleanup of the database every night, and have seen quite an increase in the perfomance of SAKAI since.
We, however, would like to know if there is a better approach to this. Keeping these stats in the database, but still being able to not have performance issues?
Any help would be appreciated.
Kind Regards,
--
Nguni Phakela
Wits University
South Africa
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
________________________________
UNIVERSITY OF CAPE TOWN
This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111<tel:%2B27%2021%20650%209111>. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
--
Nguni Phakela
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130509/26dd5aae/attachment.html
More information about the sakai-dev
mailing list