View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001781 | HTML & PERL | Bug Report - Database | public | 2010-03-13 23:07 | 2010-07-19 10:35 |
| Reporter | worf | Assigned To | DerIdiot | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Summary | 0001781: The DB-Stats "Group Stats" -> "Most users" always contains 0 | ||||
| Description | On http://anidb.net/perl-bin/animedb.pl?show=dbstats the "Group Stats" block "Most users" always shows the value 0 for all entries, thus making the whole block rather useless. | ||||
| Tags | No tags attached. | ||||
|
|
the issue is that the ucnt column is zeroed when generating the stats by the cron. just summing all the users on a per file level is no problem here and is cost wise feasible, but yields no useful dataset as it contains every user several times. doing a distinct user count here though is not as this involves walking through listtb. the cost stand in no relation to the gained usefulness of this (like 21mio cost for each 1k entries iteration). i'm very much in favour of "not fixing" this and just removing the stat. i'm not aware of any other part of the page using this column anyway. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-03-13 23:07 | worf | New Issue | |
| 2010-07-19 09:57 | DerIdiot | Status | new => acknowledged |
| 2010-07-19 10:35 | DerIdiot | Note Added: 0003143 | |
| 2010-07-19 10:35 | DerIdiot | Status | acknowledged => resolved |
| 2010-07-19 10:35 | DerIdiot | Resolution | open => fixed |
| 2010-07-19 10:35 | DerIdiot | Assigned To | => DerIdiot |
| 2010-07-19 10:36 | DerIdiot | Note Edited: 0003143 |
