Re: Quick Poll - Is anyone using SiteStats in production?

On Apr 29, 2006, at 2:16 AM, Stephen Marquard wrote:

> The tool also shows up some issues around how events are logged  
> from various tools - I'm hoping wider usage of Site Stats will lead  
> to tools improving the granularity and accuracy of what they log  
> through the event service.
>
> Cheers
> Stephen

I agree as well that this will help developers realize the value of  
events and begin to add events to new applications.

However really good event support will lead to a different problem :)

We need to handle events and sessions in a better fashion.  Currently  
these spool off into space for all perpetutity - most folks clean  
these out from time to time.

It might be nice to come up with a way to automate a process where  
these get moved from the "live" tables to the offline tables every 30  
minutes or so.  The structure of the offline tables could actually be  
slightly different than the online tables and tuned to make queries  
run really fast.  Ultimately the queries for the SiteStats tool could  
union between the (now much smaller) online tables and the offline  
tables to get the data so the users would ever see the "30 minute  
lag" - but things would perform nicely.

Then, over time, we could take the off line tables and store them by  
semester or something like that.

Just some ideas captured as http://bugs.sakaiproject.org/jira/browse/ 
REQ-412

/Chuck

[see attachment: "message0.html", size: 2442 bytes]


Attachments:

message0.html
http://collab.sakaiproject.org/access/content/attachment/0bf67a82-9d89-47c2-0059-fd02e4545c10/message0.html

----------------------
This automatic notification message was sent by Sakai Collab 
(http://collab.sakaiproject.org/portal) from the DG: Development site.
You can modify how you receive notifications at My Workspace > Preferences.