#73 Many sid-tid duples not ported on LC

closed-wont-fix
None
5
2005-09-27
2004-07-13
No

mysql> select count(distinct(concat(sid, ":", tid))) from
story_topics_old;
+----------------------------------------+
| count(distinct(concat(sid, ":", tid))) |
+----------------------------------------+
| 40542 |
+----------------------------------------+
1 row in set (0.41 sec)

mysql> select count(*) from story_topics_chosen;
+----------+
| count(*) |
+----------+
| 6383 |
+----------+
1 row in set (0.00 sec)

Stupidly, the old story_topics table didn't have sid-tid as a UNIQUE
key, but there were only a few dupes so that's not it.

There are only a handful of stories that have more than 7 tids, so
it's not a few overloaded stories skewing the numbers.

On Newsforge's DB the number for s_t_c is actually higher (81564
vs. 54768) which is what I'd expect to see. Ditto SC and UP.

Discussion

  • Jamie McCarthy

    Jamie McCarthy - 2005-08-24
    • assigned_to: jamiemccarthy --> cmdrtaco
    • status: open --> open-wont-fix
     
  • Rob Malda

    Rob Malda - 2005-09-27
    • status: open-wont-fix --> closed-wont-fix
     

Log in to post a comment.