[Building Sakai] Stats Tool

[Nguni Phakela]

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>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 listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to 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. 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/b448cf87/attachment.html