How best to collect stats for xplrionet play top 10 20 etc

["Tony Tofts" <tony@xxxxxxxxxx>]

Hi all,

I want to modify xplrionet to collect statistics of tracks played to allow
the selection of tracks by things like top 10/20/50 etc

To do this it will mean having to have a new table holding:

Date/time played, player used, track id

This does have a problem though, e.g. if you purge - the stats are
meaningless as the track id will almost certainly of changed.

We could hold the track path/name of course, but the stats table could get
horrendously big...

A way around it is for the purge to make a temporary copy of the tracks
table, then cross-reference to fix up the stats.

Of course this won't help where the tracks have been relocated, as it won't
be possible to match them off.

Also, I think when a track is played as part of a top 10/20/50 query it
probably shouldn't be added to the stats again, as this would top load the
most popular songs too much if you only listen to some of them?

Also, how many months stats should be kept?

Any thoughts/comments please?

Many thanks
Tony




xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx