This is an automated notification sent by LCG Savannah.
It relates to:
task #7548, project CDS Invenio
==============================================================================
OVERVIEW of task #7548:
==============================================================================
URL:
<http://savannah.cern.ch/task/?7548>
Summary: rnkDOWNLOADS table should be cleaned
Project: CDS Invenio
Submitted by: skaplun
Submitted on: 2008-08-06 13:19
Should Start On: 2008-08-06 00:00
Should be Finished on: 2008-08-06 00:00
Category: WebSubmit
Priority: 5 - Normal
Status: None
Privacy: Public
Percent Complete: 0%
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Effort: 0.00
_______________________________________________________
the rnkDOWNLOADS table is currently filled (by s2d project when migrating
documents from doc machine at CERN and) bibdocfile when streaming a file to
user.
Actually each time the file is streamed a row is added to this table.
This table grows indiscriminately.
It would be nice to:
* add a row only when a file is actually streamed to the user completely and
only the first time. We should not care about double clicks.
* discard robots (see task #6958)
* old data should be aggregated in a smart way (e.g. by summarizing clicks of
a year) and removed from rnkDOWNLOADS
_______________________________________________________
Carbon-Copy List:
CC Address | Comment
------------------------------------+-----------------------------
2195 | -SUB-
==============================================================================
This item URL is:
<http://savannah.cern.ch/task/?7548>
_______________________________________________
Message sent via/by LCG Savannah
http://savannah.cern.ch/
