OpenNTF.org - Open.TV

My Links (Not logged in)
User Name Password
Hosted by Prominic.NET

   Project: Open.TV (Managed by Neil Gower)
Actions:
RSS  



Response
SubjectI have an idea
Created 03/20/2010 03:08 PM by Neil Gower.
Modified03/20/2010 04:31 PM by Neil Gower.
Body

Hi,

Sounds like a nightmare, there is currently no switch to turn off view recording. I was thinking about writing a quick purge agent, and sending it to you. If your interested please email me at neilgower at gmail.com

If you dont want to email me then please follow these instructions

In the Open TV template create a new agent called "$PurgeOldViewDocuments"

The agent should be set to run more than once a day (I suggest every 30 mins), and its target should be "All Documents in Database".

You need to copy the following Notes formula in the "action" part of the edit pane


FIELD Views_Status:=@If(Views_Status="Processed";@DeleteDocument;Views_Status);
SELECT @All

and choose "Modify Documents"

This agent will purge already processed "view" documents and should clean up your db. If you want it to be even more effective increase the frequency of the running of the "$RollUp_VideoStatistics" to every 10 mins..

Hope this helps, the next version has lots of features to manage this kind of logging.





Feedback

Hide details for Log of Video Views can overwhelm da... ( on 03/01/2010 05:43:52 AM )Log of Video Views can overwhelm da... ( on 03/01/2010 05:43:52 AM )
. . I have an idea (Neil Gower on 03/20/2010 03:08:20 PM )
Check out other projects
Switch to project: